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?