List:General Discussion« Previous MessageNext Message »
From:Dan Bolser Date:May 7 2005 12:50am
Subject:amPiguous!
View as plain text  
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?


Thread
amPiguous!Dan Bolser7 May
  • Re: amPiguous!Rhino7 May
    • Re: amPiguous!Simon Garner7 May
      • Re: amPiguous!Dan Bolser7 May
    • Re: amPiguous!Eric Jensen7 May
      • Re: amPiguous!Eric Bergen7 May
        • Re: amPiguous!Dan Bolser7 May
          • Re: amPiguous!Chris7 May
            • Re: amPiguous!Jochem van Dieten7 May
    • Re: amPiguous!Dan Bolser7 May
      • Re: amPiguous!Joerg Bruehe7 May
  • Re: amPiguous!Rhino7 May
  • Re: amPiguous!Jochem van Dieten7 May
    • Re: amPiguous!Dan Bolser7 May
      • Re: amPiguous!Jochem van Dieten7 May
        • Re: amPiguous!Dan Bolser15 May