X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id B80A59257DE
	for <pgsql-sql@postgresql.org>; Mon, 19 May 2003 18:26:10 -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 40733-10 for <pgsql-sql@postgresql.org>;
	Mon, 19 May 2003 18:26:07 -0400 (EDT)
Received: from tomteboda.mdh.se (tomteboda.mdh.se [130.243.76.141])
	by developer.postgresql.org (Postfix) with ESMTP id B56C19257F0
	for <pgsql-sql@postgresql.org>; Mon, 19 May 2003 10:54:12 -0400 (EDT)
Received: from btmtsh5yqom3l1 (asl01003.lgh.mdh.se [10.37.57.1])
	by tomteboda.mdh.se (8.11.6p2/8.11.5) with SMTP id h4JEs7n00912
	for <pgsql-sql@postgresql.org>;
	Mon, 19 May 2003 16:54:07 +0200 (MET DST)
Message-ID: <004601c31e1f$04ac5c50$0139250a@btmtsh5yqom3l1>
From: "Andreas Selenwall" <asl01003@student.mdh.se>
To: <pgsql-sql@postgresql.org>
Subject: AS?
Date: Mon, 19 May 2003 16:55:06 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0043_01C31E27.663CE310"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-MailScanner: Found to be clean
X-MailScanner-SpamScore: s
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/440
X-Sequence-Number: 13605

This is a multi-part message in MIME format.

------=_NextPart_000_0043_01C31E27.663CE310
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

How do I use AS?
I want to do a JOIN but I have two columns with the same name. I thought th=
at postgresql might solve this as ACCESS does, by giving the columns names =
like Table1.id and Table2.id, but he didn't.

------=_NextPart_000_0043_01C31E27.663CE310
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>How do I use AS?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I want to&nbsp;do a JOIN but I have two co=
lumns=20
with the same name. I thought that postgresql might solve this as ACCESS do=
es,=20
by giving the columns names like Table1.id and Table2.id, but he=20
didn't.</FONT></DIV></BODY></HTML>

------=_NextPart_000_0043_01C31E27.663CE310--