----- Original Message ----- From: "Laszlo Thoth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 25, 2004 3:43 AM Subject: Re: MIN(foo) as bar WHERE bar>50
> > What version of MySQL are you running? Version 4.1.x and 5.0.x offer many > > more potential solutions than the earlier versions, which don't support > > subqueries. > > Sorry, should have specified. I am using 4.0.20, but I am under no obligation > to stick with this version. (I'm developing an application and can pick > whichever version I want: I started with 4.0.x because it seemed the most > stable.) > > I'm just as interested in learning more about SQL in general as I am in solving > this specific problem, and if there's a few ways to solve this problem I'd be > happy to consider all of them. > > (Latecomers: my original question is here: http://lists.mysql.com/mysql/173139) > Sorry, I tried for about half an hour but couldn't think of a query that would solve your problem. I expect that others on this mailing list will be able to think of a solution though. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
