From: | olle(dot)wijk(at)systecon(dot)se (Olle Wijk) |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | How do I extract ONE particular field, when multiple table contain the same field name? |
Date: | 2001-09-12 09:06:06 |
Message-ID: | 6baa8767.0109120106.67f94cf5@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Yoann | 2001-09-12 10:18:35 | Re: Combine query views into one SQL string |
Previous Message | Yoann | 2001-09-12 08:41:13 | Which SQL query makes it possible to optain the 3 greatest values of an interger list ? |