SQL复杂筛选

SELECT A.MATERIALID,A.MATERIALNAME,ISNULL(A.COMPIDSEQ,'') COMPIDSEQ,ISNULL(A.SUPPLYID,'') SUPPLYID,SUM(convert(float,A.QTY)) QTY FROM STKREMAINMATERIAL A
LEFT JOIN MSTKLOCATION B ON B.STOCKID=A.STOCKID
LEFT JOIN MSTKAREA C ON C. STOCKAREA=B.STOCKAREA
LEFT JOIN  MSTKTYPE D ON D.STOCKTYPE=C.STOCKTYPE
WHERE D.STOCKTYPE='EM01' AND (COMPIDSEQ<>'' OR SUPPLYID<>'')
GROUP BY A.MATERIALID,A.MATERIALNAME,ISNULL(A.COMPIDSEQ,''),ISNULL(A.SUPPLYID,'')
ORDER BY A.MATERIALID