Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA97741 for ; Wed, 9 Feb 2000 18:17:32 -0500 (EST) (envelope-from ken@ori-ind.com) Received: from ken (stimpy.ori-ind.com [192.168.61.96]) by orion3.ori-ind.com (8.8.7/8.8.7) with SMTP id PAA26131; Wed, 9 Feb 2000 15:29:37 -0800 Message-Id: <3.0.1.32.20000209151731.02096c70@ori-ind.com> X-Sender: ken@ori-ind.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Wed, 09 Feb 2000 15:17:31 -0800 To: Phillip Rhodes , "'pgsql-interfaces@postgreSQL.org'" From: "Ken J. Wright" Subject: Re: [INTERFACES] jdbc question In-Reply-To: <01BF7315.59104850.rhodespc@bellatlantic.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 15:50 02/09/2000 -0000, Phillip Rhodes wrote: >If I submit a query joining two tables with identical column names, how can >I differentiate the different columns and get the correct values? > >table test1 >(col1 INTEGER, >col2 INTEGER) > >table test2 >(col1 INTEGER, >col2 INTEGER) > > >select * from test1, test2 >where test1.col1 = test2.col1 select a.*, b.col1 as col3, b.col2 as col4 from test1 a, test2 b where a.col1 = b.col1 >The call >rs.getInt("col1") returns successfully with a value, but there are 2 col1 >columns in the resultset. > >Thanks, >Phillip > > >************ >