User要求經過02站的帳，求其經過02站的數量，鑽孔數，pcs SELECT A.PART_NUM,A.wipQTY,B.DRILL_QTY,C.D1_SK,C.PIECES_IN_PANEL FROM ( SELECT PART_NUM,SUM(QTY_FINISHED) wipQTY FROM CM_wip_LOT_HISTORY A WHERE A.ORGANIZATION_CODE = 'CC' AND A.PROCESS_CODE = '02' AND A.OUT_PROCESS_TIME >='01-JAN-05' AND A.OUT_PROCESS_TIME ='A' AND ( DRILL_SYM 'T' OR DRILL_SYM IS NULL) AND DRILL_SIZE NOT IN (4,5...

by shysnake - HP文档中心 - 2005-05-07 17:41:46 阅读（1382） 回复（0）