@CASE 10 < 原補材料報表 > ver-111111

原補材料報表



==========================================================

'透過年月篩選

'轉Excel
目前缺格式
或是這樣就好


'不確定是否需要轉報表



===========================================================



select a.WHCode as 倉庫代號, a.rcvpartno as 領用單號, a.rcvpartdate as 領用日期,
       b.partcode as 料號, c.partrule as 規格, b.needqty as 數量,
       d.actunicost as 單價 from tblrcvpart a
join tblrcvpartdet b on a.rcvpartno = b.rcvpartno, tblstock c, tblStockCost d
where a.whcode like 'F3' and a.rcvpartdate like '201109%'
and c.partcode = b.partcode and b.partcode = d.partcode
order by a.rcvpartno,b.partcode