From: Christian Rudow <Christian.Rudow@thinx.ch>
To: Andy Lewis <alewis@themecca.net>
Cc: PostgreSQL SQL <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] Using Aliases in Select
Date: Mon, 02 Aug 1999 16:06:34 +0200
Message-ID: <37A5A5EA.48EF2C37@thinx.ch> (raw)
References: <Pine.LNX.4.05.9908020838110.9077-100000@tmg.themecca.net>
Andy Lewis wrote:
> select tab1.name, tab1.mytext as text1, tab2.mytext as text2
> from tab1, tab2 where tab1.tab1_id = tab2.tab1_id
>
> I believe that this will fix it.
>
> Andy
Yes it does.
My knowledge of SQL all comes from working with Informix databases.
ThanX a lot !
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: Christian.Rudow@thinx.ch, alewis@themecca.net
Subject: Re: [SQL] Using Aliases in Select
In-Reply-To: <37A5A5EA.48EF2C37@thinx.ch>
References: <Pine.LNX.4.05.9908020838110.9077-100000@tmg.themecca.net> <37A5A5EA.48EF2C37@thinx.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox