insert into.. select from mult. tables

2002-02-12 Thread Justin H Deming
Hello, I'm relatively new to mysql and I've come across a problem while trying to insert values from multiple tables into a single, existing table. Here's the syntax that I'm using: insert into table1 (col1,col2,col3,col4) select Foo.col1, Foo.col2, Bar.col3, Bunk.col4 from table2 as Foo,

insert into.. select from mult. tables

2002-02-05 Thread Justin H Deming
Hello, I'm relatively new to mysql and I've come across a problem while trying to insert values from multiple tables into a single, existing table. Here's the syntax that I'm using: insert into table1 (col1,col2,col3,col4) select Foo.col1, Foo.col2, Bar.col3, Bunk.col4 from table2 as Foo,