Insert data from three tables into a new table

[oaklandar]

How would I insert data from three tables into one table using a query?

My attempt:

insert into TableFour
select * 
From TableOne, TableTwo, TableThree

It keeps saying duplicate problem.
Please advise.

 

[Lothario]

may be you need to explicitly state the table names if there are same field names in the tables...


insert into TableFour
select t1.field1,t2.field1,t3.field1
From TableOne t1, TableTwo t2, TableThree t3

-L

 

[PHV]

And maybe its advisable to join the 3 tables to avoid cartesian product.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[oaklandar]

Thanks