Skip site navigation (1) Skip section navigation (2)

RE: Select problem

From: patrick(dot)wolf(at)Aerojet(dot)com (WOLF, PATRICK)
To: "'Karl F(dot) Larsen'" <k5di(at)zianet(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: RE: Select problem
Date: 2000-08-14 15:37:56
Message-ID: 63A19D0F08E6D211AD740008C7B1C47B02FE165E@APD-MAIL1 (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)zianet(dot)com]
> Sent:	Monday, August 14, 2000 9:30 AM
> To:	pgsql-novice(at)postgresql(dot)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(at)arrl(dot)net  (505) 524-3303  -

pgsql-novice by date

Next:From: NRonayetteDate: 2000-08-14 15:55:44
Subject: Re: Select problem
Previous:From: Chris RyanDate: 2000-08-14 15:35:52
Subject: Re: Select problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group