Received: from irbrugg.net.thinx.ch (metron.agrinet.ch [212.28.128.145]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA35978 for ; Mon, 2 Aug 1999 10:06:51 -0400 (EDT) (envelope-from Christian.Rudow@thinx.ch) Received: from thinx.ch (chris@acer.net.thinx.ch [192.168.0.33]) by irbrugg.net.thinx.ch (8.8.8/8.8.8) with ESMTP id NAA07194; Mon, 2 Aug 1999 13:56:45 +0200 Sender: chris@thinx.ch Message-ID: <37A5A5EA.48EF2C37@thinx.ch> Date: Mon, 02 Aug 1999 16:06:34 +0200 From: Christian Rudow Organization: ThinX X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Andy Lewis CC: PostgreSQL SQL Subject: Re: [SQL] Using Aliases in Select References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~