這個SQL 語句你真的看明白了嗎?
SELECT * FROM 
    (SELECT CODE AS GRP_CODE,[NAME] AS GRP_NAME,GRP2 AS GRP,WFCQTY AS QTY,BOXCOUNT AS BOXNO FROM GRP4) GR
    WHERE QTY=3840 
SELECT * FROM 
    (SELECT CODE AS GRP_CODE,[NAME] AS GRP_NAME,GRP2 AS GRP,WFCQTY AS QTY,BOXCOUNT AS BOXNO FROM GRP4) GR
    WHERE QTY=3840 
