Data From Two tables using SQL
 

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

Data From Two tables using SQL
 

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/...sql_intro.html


keepITcool

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


"Soniya" wrote:

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