| two queries [message #168407] |
Thu, 20 April 2006 04:40  |
srhl
Messages: 24
Registered: December 2005
|
Junior Member |
|
|
Is it possible to have two queries but a single frame in paper layout?
how it cane be done?
I have two queries which displays the same columns but the query differs.
Thanks in advance
|
|
|
|
|
|
| Re: two queries [message #168418 is a reply to message #168415] |
Thu, 20 April 2006 05:05  |
srhl
Messages: 24
Registered: December 2005
|
Junior Member |
|
|
i have two queries but the number of columns returned by both the query is same.
is is possible to asociate the query1 with frame on some condition and query2 with the same frame for some other condition?
query1:
select name, id, start_date from employee
where
<condition1>
query2:
select name , id , decode(start_date,null,'01-jan-2000') from employee
where
<condition2>
is it possible to have only one frame for these two queries?
how reports work internally?(in detail first, it execute the query, etc......)
i'm not sure about this?
please send some links or materials regarding the same.
|
|
|
|
| Re: two queries [message #169324 is a reply to message #168418] |
Wed, 26 April 2006 05:02 |
gladiator
Messages: 21
Registered: April 2006
Location: Lahore, Pakistan
|
Junior Member |
|
|
Hi,
I think u should use the UNION to join the outputs of twe queries in order to get the single output so u can attach that with a frame
select name, id, start_date from employee
where
<condition1>
UNION
select name , id , decode(start_date,null,'01-jan-2000') from employee
where
<condition2>
Regards,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
