求SQL语句写法

[wangjidh]

表A
AID AName
1 zhang
表B
BID BName
1 li
1 liu
查询结果为
Aname Bname
zhang li
NULL liu

如何写查询语句？

[愉快的登山者]

select indentity(int,1,1) as id, * into #t from 表B
go
select A.AName, B.BName from #t as B left join 表A as A
on A.Aid = B.id
go

[newdongkui]

bid 不是1吧
select aname,bname from 表b
left join 表a on 表b.bid = 表a.aid

[SophiaWang]

表A
AID AName
1 zhang
表B
BID BName
1 li
1 liu
###这一条记录的bid不是1吧？？？如果要得出下列结果的话？？？

查询结果为
Aname Bname
zhang li
NULL liu


select aname,bname from 表B b
left join 表A a on b.bid = a.aid

[cullstar]

楼主说的不详细，能否具体些？

[wangjidh]

表A中的ID和表B中的ID一样，都是数字1。要求的查询结果是把表A和表B简单的放在一块显示出来
显示结果是：如果表A和表B的记录数量不一样，则短的那个用NULL补足。就和下边列的一样
Aname Bname
------- ---------
zhang li
NULL liu

[wangjidh]

校正 indentity 应为Identity
select identity(int,1,1) as id, * into #t from 表B
go
select A.AName, B.BName from #t as B left join 表A as A
on A.Aid = B.id
go