> How can I insert data from multiple tables into another table?
> the source tables are 3 different tables...
> I want col1 of table1 in col1 of the target-table, col6 of table2 in col2 of the
> target-table and col3 of table3 in col3 of the target-table...
> I tried this:
> insert into table dest (col1, col2, col3) SELECT col1 from table1, select col6 from
> table2, select col3 from table3;
> How can I get the data in that table?
> regards, Martin
INSERT INTO TABLE
(col1, col2, col3)
table1 AS a
,table2 AS b
,table3 AS c
a.ID = b.ID
AND b.ID = c.ID
Perhaps you need to use LEFT JOIN instead of the JOIN kommatas.
Certainly you will change the WHERE part to something useful in your case :)