Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8C9JZ791215 for ; Wed, 12 Sep 2001 05:19:35 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8C967K04318 for pgsql-sql@postgresql.org; Wed, 12 Sep 2001 05:06:07 -0400 (EDT) (envelope-from news) From: olle.wijk@systecon.se (Olle Wijk) X-Newsgroups: comp.databases.postgresql.sql Subject: How do I extract ONE particular field, when multiple table contain the same field name? Date: 12 Sep 2001 02:06:06 -0700 Organization: http://groups.google.com/ Lines: 29 Message-ID: <6baa8767.0109120106.67f94cf5@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200109/81 X-Sequence-Number: 4728 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