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]

@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

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