Hello.
It seems a bug for me. Any columns in the subquery select list must have unique names according to: http://dev.mysq.com/doc/mysql/en/unnamed-views.html I've reported a bug. You could add your comments at: http://bugs.mysql.com/bug.php?id=11864 Richard Cyganiak <[EMAIL PROTECTED]> wrote: > Hi, > > Suppose I have two tables Tbl1 and Tbl2. Both have a column called A. > > MySQL 5.0.7 rejects this query as ambiguous: > > SELECT A from Tbl1, Tbl2; > > But it accepts this and returns the A column from Tbl1: > > SELECT A FROM (SELECT * FROM Tbl1, Tbl2) AS foo; > > But this query is rejected again: > > SELECT * FROM (SELECT * FROM Tbl1, Tbl2) AS foo ORDER BY A; > > Why is this? Is it a bug? > > Thanks, > Richard > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
