--你的两个表中没有关键字段关联吗?那就用临时表:select id=identity(int,1,1),* into #t1 from A表 select id=identity(int,1,1),* into #t2 from b表select a.A,a.B,a.C,b.BB,b.CC from #t1 a join #t2 b on a.id=b.iddrop table #t1,#t2
--根据需求,试实现如下:IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'A') DROP TABLE AIF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'A') DROP TABLE A GOCREATE TABLE A(A CHAR(50),B CHAR(50),C CHAR(50))CREATE TABLE B(A CHAR(50),BB CHAR(50),CC CHAR(50)) GOINSERT A SELECT 'A','Bbbb','Cccc' UNION ALL SELECT 'AA','BB','CC' UNION ALL SELECT 'AAA','BBB','CCC'INSERT B SELECT 'A','BBbbb','CCccc' UNION ALL SELECT 'AA','BBBB','CCC' UNION ALL SELECT 'AAA','BBBB','CCC'--最终查询语句:SELECT DISTINCT A.*,B.BB,B.CC FROM A,B WHERE A.A=B.AA B C BB CC ------- ------ ---------- ----------- A Bbbb Cccc BBbbb CCccc AA BB CC BBBB CCC AAA BBB CCC BBBB CCC(所影响的行数为 3 行)--删除测试 DROP TABLE A DROP TABLE B
select id=identity(int,1,1),* into #t2 from b表select a.A,a.B,a.C,b.BB,b.CC
from #t1 a join #t2 b on a.id=b.iddrop table #t1,#t2
WHERE TABLE_NAME = 'A')
DROP TABLE AIF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'A')
DROP TABLE A
GOCREATE TABLE A(A CHAR(50),B CHAR(50),C CHAR(50))CREATE TABLE B(A CHAR(50),BB CHAR(50),CC CHAR(50))
GOINSERT A SELECT 'A','Bbbb','Cccc'
UNION ALL SELECT 'AA','BB','CC'
UNION ALL SELECT 'AAA','BBB','CCC'INSERT B SELECT 'A','BBbbb','CCccc'
UNION ALL SELECT 'AA','BBBB','CCC'
UNION ALL SELECT 'AAA','BBBB','CCC'--最终查询语句:SELECT DISTINCT A.*,B.BB,B.CC FROM A,B WHERE A.A=B.AA B C BB CC
------- ------ ---------- -----------
A Bbbb Cccc BBbbb CCccc
AA BB CC BBBB CCC
AAA BBB CCC BBBB CCC(所影响的行数为 3 行)--删除测试
DROP TABLE A
DROP TABLE B