I always put the WHERE before the GROUP BY. Can't remember if that is syntax or not.
On Fri, Jun 17, 2016 at 2:46 PM, Josh Luthman <[email protected]> wrote: > Same here. You want single quotes, no back quotes. > > > Josh Luthman > Office: 937-552-2340 > Direct: 937-552-2343 > 1100 Wayne St > Suite 1337 > Troy, OH 45373 > > On Fri, Jun 17, 2016 at 2:45 PM, Bruce Robertson <[email protected]> wrote: > >> 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! >> >> >> >
