凡科网站制作平台,软件如何推广,下载京东购物,大学网站建设与管理职责编辑器加载中... 查询一个表中所有id字段在另一个表中对应值的SQL语句怎么写#xff1f;多表联结查询:select rbd.RBDID, rbd.ProductCode,p.ProductCnName,p.[Standard],p.Impression,pb.BrandName,cgdw.UnitName,un.UnitName ,rbd.BuyingAmount,rbd.UnitPricefrom PCS_Requ…编辑器加载中... 查询一个表中所有id字段在另一个表中对应值的SQL语句怎么写多表联结查询:select rbd.RBDID, rbd.ProductCode,p.ProductCnName,p.[Standard],p.Impression,pb.BrandName,cgdw.UnitName,un.UnitName ,rbd.BuyingAmount,rbd.UnitPricefrom PCS_RequestBuyDetails as rbdleft join PM_Products as p on rbd.ProductCodep.ProductCodeleft join Cons_ProductBrands as pb on p.BrandID pb.BrandIDleft join Cons_Units as cgdw on rbd.BuyingUnitcgdw.UnitIDleft join Cons_Units as un on rbd.StockUnit un.UnitID where rbd.RBID7 另一种方法:子查询即可SELECT (SELECT name FROM TA WHERE id TB.id1) AS id1, (SELECT name FROM TA WHERE id TB.id2) AS id2FROM TB
