查询一个表中所有id字段在另一个表中对应值的SQL语句怎么写？

编辑器加载中...

查询一个表中所有id字段在另一个表中对应值的SQL语句怎么写？
多表联结查询:
select rbd.RBDID, rbd.ProductCode,p.ProductCnName,p.[Standard],p.Impression,pb.BrandName,cgdw.UnitName,un.UnitName 
,rbd.BuyingAmount,rbd.UnitPrice
from  PCS_RequestBuyDetails as rbd
left join PM_Products as p on rbd.ProductCode=p.ProductCode
left join Cons_ProductBrands as pb on p.BrandID= pb.BrandID
left join Cons_Units as cgdw on rbd.BuyingUnit=cgdw.UnitID
left join Cons_Units as un on rbd.StockUnit= un.UnitID 
where rbd.RBID=7 
另一种方法:
子查询即可
SELECT (SELECT name FROM TA WHERE id = TB.id1) AS id1,
       (SELECT name FROM TA WHERE id = TB.id2) AS id2
FROM TB