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 JAA28555 for ; Mon, 2 Aug 1999 09:22:16 -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 NAA07188 for ; Mon, 2 Aug 1999 13:12:47 +0200 Sender: chris@thinx.ch Message-ID: <37A59B9C.79D5C4FB@thinx.ch> Date: Mon, 02 Aug 1999 15:22:36 +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: PostgreSQL SQL Subject: Using Aliases in Select Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I join 2 tables that both have a row "mytext". I want to use both text fields in the select (projection) clause, giving alias names to them. select tab1.name, tab1.mytext text1, tab2.mytext text2 from tab1, tab2 where tab1.tab1_id = tab2.tab1_id but ... ERROR: Column 'mytext' is ambiguous Is there a solution to this ? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christian Rudow E-Mail: Christian.Rudow@thinx.ch ThinX networked business services Stahlrain 10, CH-5200 Brugg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~