Mysyqlworkbench is a great direct interface for doing all of your
syntax and testing.
On 06/17/2016 01:55 PM, Josh Luthman wrote:
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]
<mailto:[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]
*Sent:* Friday, June 17, 2016 12:48 PM
*To:* [email protected] <mailto:[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] <mailto:[email protected]>>
wrote:
Same here. You want single quotes, no back quotes.
Josh Luthman
Office: 937-552-2340 <tel:937-552-2340>
Direct: 937-552-2343 <tel:937-552-2343>
1100 Wayne St
Suite 1337
Troy, OH 45373
On Fri, Jun 17, 2016 at 2:45 PM, Bruce Robertson
<[email protected] <mailto:[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]
<mailto:[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!
