Combining data from 4 tables into 1

  • Thread starter Thread starter Naz
  • Start date Start date
N

Naz

Hi All,

I have four tables all with identical fields. How do I
create a new table that combines all the records from all
four tables? Can anyone help?

Cheers

Naz
 
Naz,

As all the tables have yhe same columns use this:

Create a new union query as follows:

Select * from table1
union all
Select * from table2
union all
Select * from table3
union all
Select * from table4

save this query as query1 (or aany name)


writea second query: Query2:

Select * into newtable from query1


I hope this helps.


SAM
 
Back
Top