SQL Server Performance Forum – Threads Archive
Insert Into …Values from Other table
Hi , could you help me pls ?I need to write some code with use Insert into , but Values are some values from other table INSERT Into MyTmpTable (COl1,col2) Values (det.col1, lin.col2) from Detail Lin Links Lin
where ….something … I have tried to write some statements but it was wrong.
Thanks, lubo
INSERT Into MyTmpTable (COl1,col2)
select det.col1, lin.col2
from Detail det
join Links Lin on ….
where ….
Study syntax, explanations and examples in Books on-Line (BOL)
]]>