Hi Folks,
I have a problem regarding selection criteria. The selection criteria does not allow us to do unions kind of stuff.

What if I want my query (via selection criteria) to look like this.....

select 1,2
from tab1 a,tab2 b
where a.id*=b.id
union
select 1,2
from tab3

Is it possible in crystal reports (not via VB but stright CR8.5)???

Please help......

Regards


jaideep