Received: from smtp-out2.bellatlantic.net (smtp-out2.bellatlantic.net
	[199.45.39.157]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA12799
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 9 Feb 2000 15:50:33 -0500 (EST)
	(envelope-from rhodespc@bellatlantic.net)
Received: from rhodespc (adsl-151-201-19-84.bellatlantic.net [151.201.19.84])
	by smtp-out2.bellatlantic.net (8.9.1/8.9.1) with SMTP id PAA16033
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 9 Feb 2000 15:50:03 -0500 (EST)
Received: by localhost with Microsoft MAPI; Wed, 9 Feb 2000 15:50:11 -0000
Message-ID: <01BF7315.59104850.rhodespc@bellatlantic.net>
From: Phillip Rhodes <rhodespc@bellatlantic.net>
To: "'pgsql-interfaces@postgreSQL.org'" <pgsql-interfaces@postgreSQL.org>
Subject: jdbc question
Date: Wed, 9 Feb 2000 15:50:10 -0000
X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

The call
rs.getInt("col1") returns successfully with a value, but there are 2 col1 
columns in the resultset.

Thanks,
Phillip