求一条Sql语句

[lennox]

有表A
id nId1 nId2
---------------
1 1 2
(nId1,nId2对就表B中的ID)

表B
id Name
-------
1 AAA
2 BBB

要求查询出如
id Name1 Name2
---------------
1 AAA BBB

Sql语句应该怎么写
除了
select A.id,B1.Name,B2.Name
from A,B B1,B B2
where A.nId1 = B1.id and A.nId2 = B2.id and A.id = 1
外，还能怎么实现!

[letqqqgo]

这样也是可以的：
select a.id,
(select name from B where b.nId1 = a.id) as Name1,
(select name from B where b.nId2 = a.id) as Name2
from A a

[start_again]

select a.id as id ,(select name from b where b.id=a.nid1) as name1,(select name from b where b.id=a.nid2) as name2 from a