RE: Select problem

try inserting the table name in the select, like this:

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

Pat
> -----Original Message-----
> From:    Karl F. Larsen [SMTP:k5di@zianet.com]
> Sent:    Monday, August 14, 2000 9:30 AM
> To:    pgsql-novice@postgresql.org
> Subject:    [NOVICE] Select problem
>
>
>     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  -