Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90])
	by hub.org (8.9.2/8.9.1) with ESMTP id KAA53243
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 22 Feb 1999 10:52:38 -0500 (EST)
	(envelope-from uucp@Uucp1.mcs.net)
Received: from uucphost.mcs.net (Uucp1.mcs.net [192.160.127.93]) by
	Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id JAA18510;
	Mon, 22 Feb 1999 09:52:27 -0600 (CST)
Received: (from uucp@localhost) by uucphost.mcs.net (8.8.8/8.8.8) id JAA25981;
	Mon, 22 Feb 1999 09:52:26 -0600 (CST)
Received: by idm.com (sender: <bvonmoss@idm.com>) id <m10Exa1-0000rWC@idm.com>
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 22 Feb 1999 09:47:33 -0600 (CST)
	(Smail-3.2.0.98 1997-Oct-16 #22 built 1997-Dec-3)
Sender: rwv@Uucp1.mcs.net
Message-ID: <36D17C14.4384F7D8@idm.com>
Date: Mon, 22 Feb 1999 09:47:33 -0600
From: Bob VonMoss <bvonmoss@idm.com>
Reply-To: bvonmoss@bigfoot.com
X-Mailer: Mozilla 4.05 [en] (X11; I; SCO_SV 3.2 i386)
MIME-Version: 1.0
To: philip.shiels@jrc.it
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Tables names from query
References: <36D15B0D.B57DB69C@jrc.it>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Philip Shiels wrote:

> SELECT x.y, z.y from x, y where x.key = z.key
>
> The problem with the above is that I get back 2 fields called 'y' and have no
> way of knowing from which tables they've come from.

Do something like this:

SELECT x.y, z.y AS z_y from x, z where x.key = z.key;

> Is there is a way of identifying the originating tables ?