Something like this?
Insert Table3 (ColA,ColB,ColC)
Select Table1.Col1,Table1.Col2,Table2.Col3
From Table1 Inner Join Table2 On Table1.Id=Table2.Pid
Where Conditions
Save our world, its all we have! A must watch video
Pale Blue Dot Please use the search feature of the forum before asking a question.