Re: Select problem

    You are exactly right Joe. Thanks and I found another way which
sometimes works. It goes

    select data.* , user
    from......

when you want all from table "data" and user from another.


On Mon, 14 Aug 2000, Joe LaLumiere wrote:

> >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?
>
> Since you have two tables which have the same field name you need to specify which table to grab the field from.  The
correctedselect statement would be: 
>
>     select user, user.armycall
>     from data, biglist
>     where user.armycall = biglist.armycall
>
> OR
>
>     select user, biglist.armycall
>     from data, biglist
>     where user.armycall = biglist.armycall
>
> Either of these two will work.  The above applies to any two fields which have the same name in two or more tables.
>
> Joe LaLumiere
>
> >
> >Yours Truly,
> >
> >       - Karl F. Larsen, k5di@arrl.net  (505) 524-3303  -
> >
> >
> >
> ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
>  \   Joseph LaJeunesse-LaLumiere  /  Phone: (781) 276-6816     \  TIAC - The Internet Access Company  /
>   \  Systems Administrator I     /   Pager: (617) 473-2573      \      - A Division of Inter.net     /
>    \ Inter.net - Bedford MA     /    Email: joelight@tiac.net    \                                  /
>     ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
>
>

Yours Truly,

       - Karl F. Larsen, k5di@arrl.net  (505) 524-3303  -