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