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

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.


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…:slight_smile: