X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id DEFBC923287 for ; Fri, 23 May 2003 01:18:24 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 53825-01 for ; Fri, 23 May 2003 01:17:53 -0400 (EDT) Received: from wolff.to (wolff.to [66.93.249.74]) by developer.postgresql.org (Postfix) with SMTP id 907AA92577B for ; Thu, 22 May 2003 21:46:57 -0400 (EDT) Received: (qmail 14206 invoked by uid 500); 23 May 2003 01:48:57 -0000 Date: Thu, 22 May 2003 20:48:57 -0500 From: Bruno Wolff III To: Andreas Selenwall Cc: pgsql-sql@postgresql.org Subject: Re: AS? Message-ID: <20030523014857.GB13701@wolff.to> Mail-Followup-To: Andreas Selenwall , pgsql-sql@postgresql.org References: <004601c31e1f$04ac5c50$0139250a@btmtsh5yqom3l1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <004601c31e1f$04ac5c50$0139250a@btmtsh5yqom3l1> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/448 X-Sequence-Number: 13613 On Mon, May 19, 2003 at 16:55:06 +0100, Andreas Selenwall wrote: > How do I use AS? > I want to do a JOIN but I have two columns with the same name. I thought that postgresql might solve this as ACCESS does, by giving the columns names like Table1.id and Table2.id, but he didn't. You should be able to qualify the column names with the table names. Why don't you show us what you did and what results you got.