Re: Complex Query

2011-05-21 Thread Hal�sz S�ndor
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 r

RE: Complex Query

2011-05-21 Thread Mimi Cafe
Bizarre! That worked, but it appears the alias is not used. Thanks Mimi => -Original Message- => From: Hal�sz S�ndor [mailto:h...@tbbs.net] => Sent: 21 May 2011 01:48 => To: Johan De Meersman => Cc: Mimi Cafe; mysql@lists.mysql.com; Johan De Meersman; Guido => Schlenke => Subje