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 => 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
