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