货区打印机维护

SELECT a.stockid,A.STOCKAREAID,A.GOODSAREAID,A.PRINTERID,A.PRINTTYPE,A.ACTIONFLG,B.NAME AS GOODSAREANAME,C.PRINTERNAME  
FROM PRINTTYPEGOODSAREAMST A,GOODSAREAMST B,PRINTERMST C,PRINTTYPEMST D 
WHERE A.STOCKID=B.STOCKID AND A.STOCKAREAID=B.STOCKAREAID AND A.GOODSAREAID=B.GOODSAREAID AND A.PRINTERID=C.PRINTERID 
AND A.PRINTERID=D.PRINTERID  AND A.PRINTTYPE=D.PRINTTYPE 

AND A.PRINTERID LIKE 'CP3%'
AND A.PRINTTYPE = (SELECT A.CODEVALUE FROM BASEDETAILMST A WHERE CODEID='SYS_PRINTTYPE' AND NAME = '入库标签')