【資料處理】大庫訂貨資料匹配

標籤：資料   2014   ar   ef   ui   rom   on   select   

select  distinct a.商品編碼,a.品名,a.規格,a.最終進價 大庫價格,c.curcsprc 進價,a.最終進價-c.curcsprc 價差,d.qty 西部,e.qty 東部,f.qty 中區
from lhdh201408 a
left join lhspm b on a.商品編碼=b.pluid
left join 商品碼 c on b.barcode=c.bcd
left join (select pluno,sum(qty) qty from xbxs where rq between ‘20140501‘ and ‘20140801‘ group by pluno ) d on c.pluno=d.pluno
left join (select pluno,sum(qty) qty from dbxs where rq between ‘20140501‘ and ‘20140801‘ group by pluno ) e on c.pluno=e.pluno
left join (select pluno,sum(qty) qty from zqxs where rq between ‘20140501‘ and ‘20140801‘ group by pluno ) f on c.pluno=f.pluno
order by 2