Insert Into …Values from Other table | SQL Server Performance Forums

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)