Select problem - Mailing list pgsql-novice

    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  -