From: Date: May 7 2005 12:50am
Subject: amPiguous!
List-Archive: http://lists.mysql.com/mysql/183724
Message-Id: <Pine.LNX.4.21.0505062347320.24340-100000@mail.mrc-dunn.cam.ac.uk>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


Why are columns included in the join between two tables ambigious?

It seems that they should *not* be ambigious!

Like this

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?