Re: Select problem

On Mon, 14 Aug 2000, Karl F. Larsen wrote:

>
>     I have a simple 3 table database with armycall as the common key
> and it all works fine when I doa select like so:
>
>     select user, doer
>     from data, biglist
>     where user.armycall = biglist.armycall;
>
> but if I want to get the column armycall and use:
>
>     select user, armycall
>     from data, biglist
>     where user.armycall = biglist.armycall
>
> I get an error that armycall is ambiguous.
>
>     Does anyone know how to correct this?
>
> Yours Truly,
>
>        - Karl F. Larsen, k5di@arrl.net  (505) 524-3303  -
>

You need to tell the SELECT which armycall you want since it is in both
tables. Yes, the values are identical due to the WHERE clause, but the
parser really doesn't know this. So try:

select user, data.armycall
from data, biglist
where data.armycall = biglist.armycall

Note - I think you have a transcription error in your example because you
said user.armycall, not data.armycall in the WHERE clause.

Anyway, I hope this helps,
John