Insert Data using joins.

Question

How to insert data using join with two table in sql. Please solve this problem

Sachin Singh · Answer

You can simple insert in first table then with the scope identity insert the values in second table.

Joginder Banger · Answer

INSERT INTO Table1 (Field1, Field2) SELECT a.Field1, b.Field2 FROM TableA a INNER JOIN TableB b ON a.ID = b.ID try this way

Amira Bedhiafi · Answer

Can you please share a sample of your data ?

Jignesh Kumar · Answer

Hi Saurabh, Please use below query, Insert into table3 values (column1,Column2, Column3) SELECT Column1, Column2, Column3 frOM Table1 t1 INNER JOIN table2 t2 ON t1.Id= t2.Id

Vishvjit Shinde · Answer

Insert into YourTable(column1,column2) select a.column1,b.column2 from Table1 a [YourJOin] Table2 b on a.id = b.id

Rajanikant Hawaldar · Answer

Correct me if I understand wrong https://www.w3resource.com/mysql/inserting-updating-deleting/insert-with-left-join.php https://stackoverflow.com/questions/20404682/sql-insert-into-from-multiple-tables/20404789 https://stackoverflow.com/questions/52382378/insert-statement-with-a-join-between-two-tables https://dba.stackexchange.com/questions/71852/how-to-insert-values-into-a-table-from-two-different-tables

Harsh Shah · Answer

INSERT INTO Table1 (column1, column2) SELECT a.column1, b.column2 FROM TableX a INNER JOIN TableY b ON a.id = b.id

Insert Data using joins.

Answers (7)