Phpmyadmin takes care of all the syntax for you =)
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:53 PM, <[email protected]> wrote: > 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] <[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! >>> >>> >>> >> > >
