谁能帮写个SQL,解决一下问题,急需解决,谢谢!

[涛声宜旧]

A表:
AaID AbID AcID
22 33 44
66 77 88
B表:
ID Name
22 苹果
33 梨
44 桔子
77 桃
88 杏
66 香蕉
23 芒果
两表关系为:AaID,AbID,AcID分别为B表ID中的值,现在要得到
AaID AbID AcID
苹果 梨 桔子
香蕉 桃 杏

[Alang_79]

select (select name from B where ID = A.AaID) as AaID,
(select name from B where ID = A.AbID) as AbID,
(select name from B where ID = A.AcID) as AcID
from A

[涛声宜旧]

噢,谢谢了,一会儿结贴