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
This is my first post. I hope it works and please excuse me if I screw
up.
I have an MS Access database I'm trying to convert to MySQL v4.0.3 for
Netware. I use a VB frontend to talk to my .mdb file. So far I've gotten
all my data into MySQL using the MyAccess tool I bought. In my VB
frontend I'v
