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

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 (view raw or flat)
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

pgsql-novice by date

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

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