连关联条件都没说,怎么连?举个花生楼主看一下吧: select a.a,b.b from 表1 a left join 表2 b on a.id=b.id
SELECT ID=IDENTITY(INT,1,1),* INTO #TBA FROM A SELECT ID=IDENTITY(INT,1,1),* INTO #TBB FROM BSELECT 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 INSERT TB3(COL1,COL2) SELECT T.COL1,T1.COL1 FROM #TBA T JOIN #TBB T1 ON T.ID=T1.ID
表1 内ta字段有三条记录,如 a 1 2 3 表2 内tb字段有三条记录,如 b a b c 用SQL语句怎么能把这两个表联系起来生成一个表,结果为 a b 1 a 2 b 3 c alter table ta add b1 nvarchar(128)update ta set b1=b from tbselect a,b1 from ta
select a.a,b.b from 表1 a
left join 表2 b on a.id=b.id
SELECT ID=IDENTITY(INT,1,1),* INTO #TBA FROM A
SELECT ID=IDENTITY(INT,1,1),* INTO #TBB FROM BSELECT 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
INSERT TB3(COL1,COL2) SELECT T.COL1,T1.COL1 FROM #TBA T JOIN #TBB T1 ON T.ID=T1.ID
a
1
2
3
表2 内tb字段有三条记录,如
b
a
b
c
用SQL语句怎么能把这两个表联系起来生成一个表,结果为
a b
1 a
2 b
3 c
alter table ta add b1 nvarchar(128)update ta set b1=b from tbselect a,b1 from ta