已知 表A,表BA 表记录为 B表为字段 A 字段AA 字段A 字段BB
A A1 A B1
A A2 A B2
A AN A BN
. . . .
. . . .
求.如下表
生成的表为 :tableAB字段A 字段AA 字段BB
A A1 B1
A A2 B2
A AN BN
A A1 A B1
A A2 A B2
A AN A BN
. . . .
. . . .
求.如下表
生成的表为 :tableAB字段A 字段AA 字段BB
A A1 B1
A A2 B2
A AN BN
select id=identity(int,1,1) , * into b1 from bselect a1.a,a1.aa,b1.bb from a1,b1 where a1.id = b1.id
A A2 B2
A AN B1
?还有他们对应记录数相等吗?
insert A select 'A', 'A1'
union all select 'A', 'A2'
union all select 'A', 'AN'
create table B(A varchar(10), BB varchar(10))
insert B select 'A', 'B1'
union all select 'A', 'B1'
union all select 'A', 'BN'select ID=identity(int, 1, 1), * into #A from A
select ID=identity(int, 1, 1), * into #B from B
select #A.A, #A.AA, #B.BB from #A, #B
where #A.ID=#B.ID--result
A AA BB
---------- ---------- ----------
A A1 B1
A A2 B1
A AN BN(3 row(s) affected)