RE: Complex Query

[Mimi Cafe]

Bizarre! That worked, but it appears the alias is not used.

Thanks

Mimi

=> -----Original Message-----
=> From: Hal�sz S�ndor [mailto:hsv@stripped]
=> Sent: 21 May 2011 01:48
=> To: Johan De Meersman
=> Cc: Mimi Cafe; mysql@stripped; Johan De Meersman; Guido
=> Schlenke
=> Subject: Re: Complex Query
=> 
=> >>>> 2011/05/21 00:22 +0200, Johan De Meersman >>>>
=> Heh. The parser is pointing out a simple syntax oversight, yes. The
=> correct syntax for that is select ... from (subselect) aliasname;
=> <<<<<<<<
=> And that is required whether the alias is used or not. I at those
=> times have been tripped up by this requirement when I had no use for
=> the alias.