mber 12, 2002 02:05
To: Ed Reed; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Newbie Question - Query works in access but not MySQL
Do you have a space between PartNumber and Like?
Also there's not need to ORDER BY - the GROUP BY does that anyway (I
know that's the case elsewhere)
ts.Obsolete<>-1))
> GROUP BY Products.PartNumber;
Mark
-Original Message-
From: Alan McDonald [mailto:alan@;meta.com.au]
Sent: Tuesday, November 12, 2002 02:05
To: Ed Reed; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Newbie Question - Query works in access but not M
PROTECTED]
> Subject: Re: Newbie Question - Query works in access but not MySQL
>
>
> UPDATE:
>
> Still trying to solve this and I think I have something that's a little
> easier to understand. If I run the following query against MySQL it
> returns "Unknown column &
UPDATE:
Still trying to solve this and I think I have something that's a little
easier to understand. If I run the following query against MySQL it
returns "Unknown column 'Obsolete' in 'having clause'". If I run the
query using MSAccess as a frontend to MySQL the query runs correctly (it
returns
I came up with a translation to the first query, which had the two
sub-selects, and it now seems to work. I've yet to come up with a
solution to the second query, which had the Group By clause. I'd still
like to hear some ideas.
- Ed
>>> "Ed Reed" <[EMAIL PROTECTED]> 11/11/2002 8:03:03 PM >>>
Th
