| Report query [message #169969] |
Mon, 01 May 2006 02:42  |
amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore
|
Junior Member |
|
|
Hi All
I want to know how to display a field data which is in number of table.e.g. I have to display gross salary of a emp for a year but gross salary is in number of table like empgros_01 for jan,empgros_02 for feb,-----empgros_12 for dec.I have to prepare a report for particular emp having gross from january to December giving empno,payperiod as input.
waiting for reply
Bye
|
|
|
|
| Re: Report query [message #170010 is a reply to message #169969] |
Mon, 01 May 2006 13:09  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Maybe you can create a view which unions the data you need? Like:
select col1 column_desc_1
, col2 column_desc_2
from tab1
UNION
select col1 column_desc_1
, col2 column_desc_2
from tab2
UNION
...
UNION
select col1 column_desc_1
, col2 column_desc_2
from tabn
Regards,
Sabine
|
|
|
|
| Re: Report query [message #170074 is a reply to message #170010] |
Tue, 02 May 2006 00:09 |
amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore
|
Junior Member |
|
|
Hi
Thanks.But this will not solve my problems.My question is I want to select gross salary of a emp,grosss salary is in number of table eg tab_01 for jan,tab_02 for feb.now i give the input empno,payperiod like 200406.as output i want empno, payperiod, gross salary from 200401 to 200406.
empno payperiod grosssal
1234 200401 10000
200402 10000
200403 10000
so on till 200406
bye
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
