Tables column insert(right join ,inner join,left join etc...)

[jemz]

Hi, Can i ask is it possible to insert records to the multiple table using join statements or left join, right join etc..?

Thank you in advance.

[r937]

no

the INSERT statement can only insert into one table at a time, although it's possible to insert multiple rows with one statement

[jemz]

no

the INSERT statement can only insert into one table at a time, although it's possible to insert multiple rows with one statement

Hi r937,Thank you for enlighten my mind...so this is not possible to use in join statement..