WHERE comes before GROUP BY Dave
On Jun 17, 2016, at 2:44 PM, [email protected]<mailto:[email protected]> wrote: I am not a SQL guy, so I have to self teach each time for the most basic things. This statement: SELECT PART_ID, QTY, TRANSACTION_date, PURCHASE_ID, SEQ_NO, RECEIVER_ID, WORK_ID, CLASS FROM INVENTORY_INV_TRAN GROUP BY PART_ID, QTY, TRANSACTION_DATE, PURCHASE_ID, SEQ_NO, RECEIVER_ID, WORK_ID, CLASS WHERE CLASS='PO_RECEIPT’; Does not work. Says there is: Incorrect syntax near the keyword 'WHERE'. It also shows the ‘ when typing ‘PO_RECEIPT’ as red and all the subsequent chars as red too. If I use “ instead they look ok but it still throws the error. Help?
