Thread

Re: Select problem

Karl F. Larsen <k5di@zianet.com> — 2000-08-14T17:23:12Z

	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 corrected select 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  -