user3649739 user3649739 - 5 months ago 17
SQL Question

Insert with Multiple Joins

I figured out how to do a multiple table join update but am not clear how to set up as an Insert instead. This was my update:

Update TableA as T1
Inner Join TableB T2
Inner Join TableC T3
On T3.A=T1.A and T3.B=T2.Band T1.C=T2.C
Set T1.B=T3.B


Now I am trying to do the same thing except I want to insert vs updating a record. Is that possible?

Answer

This is INSERT AS SELECT :

INSERT INTO Table1 (Col1,Col2,Col3.....)
SELECT t2.Col1,t3.Col2,t3.Col3....
FROM TableB t2
INNER JOIN TableC t3
 ON(t2.band = t3.b)

If you want to include/exclude some of Table1 data so add it to the joins as well.

Comments