Re: AS? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: AS?
Date
Msg-id 20030523014857.GB13701@wolff.to
Whole thread Raw
In response to AS?  ("Andreas Selenwall" <asl01003@student.mdh.se>)
List pgsql-sql
On Mon, May 19, 2003 at 16:55:06 +0100, Andreas Selenwall <asl01003@student.mdh.se> 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.


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: tablename as attribute in pgplsql
Next
From: Stephan Szabo
Date:
Subject: Re: Another sub-select problem...