pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Eckermann <jeckermann@verio.net>
To: Olle Wijk <olle.wijk@systecon.se>
To: pgsql-sql@postgresql.org
Subject: Re: How do I extract ONE particular field, when multiple table contain the same field name?
Date: Fri, 14 Sep 2001 16:35:32 -0500
Message-ID: <02ee01c13d65$2ff1c6d0$279c10ac@INTERNAL> (raw)
References: <6baa8767.0109120106.67f94cf5@posting.google.com>

You need to qualify "DENOM" with the table name: just write "xi.DENOM".
I find this to be good general practice when selecting from more than one
table.

----- Original Message -----
From: "Olle Wijk" <olle.wijk@systecon.se>
To: <pgsql-sql@postgresql.org>
Sent: Wednesday, September 12, 2001 4:06 AM
Subject: How do I extract ONE particular field, when multiple table contain
the same field name?


> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>




view thread (6+ messages)

Message-ID: <02ee01c13d65$2ff1c6d0$279c10ac@INTERNAL>
Permalink:  ../02ee01c13d65$2ff1c6d0$279c10ac@INTERNAL/
Also on:    postgresql.org/message-id/02ee01c13d65$2ff1c6d0$279c10ac@INTERNAL

 · 

reply

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: jeckermann@verio.net, olle.wijk@systecon.se
  Subject: Re: How do I extract ONE particular field, when multiple table contain the same field name?
  In-Reply-To: <02ee01c13d65$2ff1c6d0$279c10ac@INTERNAL>

* 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