一个查询问题。(50分)

A表<br>ID Name<br>1 &nbsp;Name1<br>2 &nbsp;Name2<br><br>B表<br>AID BID<br>1 &nbsp; 2<br>2 &nbsp; 1<br>要求结果<br>AID BID &nbsp;AIDName BIDName<br>1 &nbsp; 2 &nbsp; &nbsp;Name1 &nbsp; Name2<br>2 &nbsp; 1 &nbsp; &nbsp;Name2 &nbsp; Name1

select AID,BID,<br>AIDName=(select Name from tableA where ID=AID),<br>BIDName=(select Name from tableA where ID=BID)<br>from tableB

基本如上。。。