From: olle.wijk@systecon.se
To: pgsql-sql@postgresql.org
Subject: How do I extract ONE particular field, when multiple table contain the same field name?
Date: 12 Sep 2001 02:06:06 -0700
Message-ID: <6baa8767.0109120106.67f94cf5@posting.google.com> (raw)
Hi,
I am pretty new att using SQL-quires, could anyone help me with this
one:
I want to do the following SQL-query:
Select XID, DENOM, PRICE, FRT, CTID From XItem xi, Category c Where
xi.System=1 and xi.Category=c.Index
the problem is that the field 'DENOM' is present in both table 'XItem'
and
'Category' (it is a text description field where you explain whatever
you
want). Therefore I get the following complaint when I run the query:
Error msg: "The specified fiel 'DENOM' could refer to more than one
table listed
in the FROM clause of your SQL-statement"
The DENOM-field I actually want is the one belonging to the
XItem-table.
I would most appreciate if someone could give me a hint how to alter
the
SELECT-statement above so that it does what I want.
Regards
/olw
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: olle.wijk@systecon.se
Subject: Re: How do I extract ONE particular field, when multiple table contain the same field name?
In-Reply-To: <6baa8767.0109120106.67f94cf5@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox