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)

---

]]>