Data From Two tables using SQL

[Soniya]

Hi All,

Is it possible to get data from two tables to a single
sheet using sql?

Both tables do have several same fields but not all.

TIA

Soniya

 

[keepITcool]

Soniya, try using the UNION keyword


select * from Table1 where Field1 = 'criteria'
union
select * from Table2 where Field1 = 'criteria'





You'll find a handy reference to SQL for JET
on
http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >