Select problem

From: "Karl F(dot) Larsen" <k5di(at)zianet(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Select problem
Date: 2000-08-14 15:29:54
Message-ID: Pine.LNX.4.10.10008140923120.989-100000@cannac.ampr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)arrl(dot)net (505) 524-3303 -

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Chris Ryan 2000-08-14 15:35:52 Re: Select problem
Previous Message chriswood 2000-08-14 13:02:42 What does this pgAdmin error mean?