Don't use select *, it is considered bad practice anyway.

List the columns you need, and only list columnname once:

select A.columnname, A.foo, B.bar, etc.

I am attempting to access a result set from a query that has the same column name in both tables.

select * from TABLE_A A, TABLE_B B where A.columnname = B.columnname

when I attempt to access the result set:

statement.execute();

ResultSet rs = statement.getResultSet();

rs.next();



I get Exception:

Any ideas