Yeah, I just now puzzled it out, that was indeed it. Thanks for the help everyone. For some reason I never remember any SQL syntax between SQL jobs.
I suppose if I had to use it a whole bunch at some point in my life perhaps some of this stuff would stick. From: mailto:[email protected] Sent: Friday, June 17, 2016 12:48 PM To: [email protected] Subject: Re: [AFMUG] OT SQL Query Help 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!
