Re: amPiguous!

[Jochem van Dieten]

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