>Dear Naomi
>
>If data in tables look like this
>
>
>Create table table11 (date d(8),title1 Char(15),name1 Char(20),amount n(5))
>
>Insert Into table1 Values ({^2009-01-05},'BILL','TUSHAR',18)
>Insert Into table1 Values ({^2009-01-06},'MARTIN','CESAR',72)
>Insert Into table1 Values ({^2009-01-07},'DALE','MIKE',63)
>
>
>Create table table2 (datex d(8),title1x Char(15),name1x Char(20),amountx n(5))
>
>Insert Into table2 Values ({^2010-01-15},'CETIN','JUN',71)
>Insert Into table2 Values ({^2010-01-16},'ANIL','ERIC',62)
>Insert Into table2 Values ({^2010-01-17},'SAMIR','ANDERS',13)
>
>
>Then? I think there will be no JOIN or UNION
select * from Table1 ;
UNION ALL ;
select * from Table2 ;
ORDER BY 1 ;
into cursor csrReport NOFILTER
If it's not broken, fix it until it is.
My Blog