On Tue, 2 Dec 2003 10:47:07 +0100 "Wouter van Vliet" <[EMAIL PROTECTED]> wrote: > If you want to select those who HAVE BEEN at level 2 in the yeaer Y, > you can just do "level_id = 2". But I guess you want to know who > currently IS at level 2 IN the year Y? In that case, when using a
Yes, that's what I'm trying to do. > 4.0.x I guess there is no way you are going to do that. I tried and > couldn't. I know though, that with a little more puzzling I could do > it in 4.1.x since (as I heard) that one supports the so-called > "subselects". > > For now, you'd be stuck with a little bit of some sort of scripting > language to parse the results... i'm sorry. >From what I've gathered, I was afraid that I would probably need to resort to subselects, but switching to 4.1.x is not acceptable right now. Post-processing results in the client would also mean a huge performance hit, but I guess I'll have to look into it. Could you give me an example of such subselects so I can see what to make of it? Can this be even done in any SQL implementation without the aid of client post-processing or procedures? -- Skippy - Romanian Web Developers - http://ROWD.ORG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]