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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 -
From | Date | Subject | |
---|---|---|---|
Next Message | NRonayette | 2000-08-14 15:55:44 | Re: Select problem |
Previous Message | Chris Ryan | 2000-08-14 15:35:52 | Re: Select problem |