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