If that's a direct cut and paste, I see two different types of single
quotes around PO_RECEIPT.
On 06/17/2016 11:44 AM, [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?
!DSPAM:2,57644507308732112720041!
