[thelist] MySQL subquery

Robert Gormley robert at pennyonthesidewalk.com
Fri Oct 28 01:59:13 CDT 2005


Assuming Paul's reply didn't help... you could do the same thing with a 
temp. table. Ugly, but the 'best' way to do it. Ideally, look at an 
upgrade to 4.1, considering 5.0 is now in production, 4.0 is becoming 
obsolete.

Rob

On Thu, 27 Oct 2005, Mark Groen wrote:

> I've got a conundrum in that MySQL < 4.1 does not support subqueries. Is
> there another way to do a query such as this one below without
> upgrading?:



More information about the thelist mailing list