62,040
社区成员
发帖
与我相关
我的任务
分享
SELECT ID=IDENTITY(INT,1,1),* INTO #TBA FROM A
SELECT ID=IDENTITY(INT,1,1),* INTO #TBB FROM B
INSERT TB3(COL1,COL2) SELECT T.COL1,T1.COL1 FROM #TBA T JOIN #TBB T1 ON T.ID=T1.ID
SELECT ID=IDENTITY(INT,1,1),* INTO #TBA FROM A
SELECT ID=IDENTITY(INT,1,1),* INTO #TBB FROM B
SELECT T.COL1,T1.COL1 FROM #TBA T JOIN #TBB T1 ON T.ID=T1.ID