34,590
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO A(Col1,Col2,Col3)
SELECT B.Col1,C.Col2,C.Col3
FROM B JOIN C ON B.ID=C.ID
JOIN D ON B.NAME=D.NAME
SELECT B.Col1,C.Col2,C.Col3
INTO #tmp
FROM B JOIN C ON B.ID=C.ID
JOIN D ON B.NAME=D.NAME;
INSERT INTO A(Col1,Col2,Col3)
SELECT Col1,Col2,Col3
FROM #tmp