SQL多表联合查询问题

显示全部楼层 · 2013-7-26 11:09:37

select 商品代码=a.SPDM,
仓库代码=case when b.CKDM is null then c.CKDM else b.CKDM end,
b.发货数量,
c.销售数量from 表A aleft join(select SPDM,CKDM,发货数量=sum(SL) from 表B group by SPDM,CKDM) bon a.SPDM=b.SPDMleft join(select SPDM,CKDM,销售数量=sum(SL) from 表C group by SPDM,CKDM) con a.SPDM=c.SPDM...

千问 · 2013-7-26 11:09:37

select xxx from (a inner join b on xx=xx) inner join c on xx=xx where xx不外就是 ineer join 或 left join 还有right join的区别，不清楚你的数据结构，所以你自己去组合吧。...