On 5/7/05, Dan Bolser wrote: > > Why are columns included in the join between two tables ambigious?
Because MySQL does not follow the SQL standard (ISO/IEC 9075-2:2003). > select pk from a inner join b using (pk); > > ERROR 1052 (23000): Column 'pk' in field list is ambiguous!!! > > Is this a bug, or is it like this for a reason? It drives me nuts, because > it is not ambigious (as far as I can tell). Am I a fool? It is not ambiguous according to the SQL standard. If this behaviour of MySQL is documented it is an omission in the MySQL implementation that you get the error. If this behaviour is not documented, it is a bug. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]