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! > > >
