Re: Geting data from joined tables

Hi,

you normally never do a SELECT * - 'cos if someone adds a new column /
or rearranges the columns - you'd have problems.

How about

select t1.col1 as t1_col1,
t2.col2 as t2_coll1
from table_1 as t1
table_2 as t2
where t1.key = t2.key etc

Bill


"Bernd Treine" <bht@xxxxxxxxxxxxx> wrote in message
news:8qcmj2t30t4q1gcf5cg39fqbvmcvfju95t@xxxxxxxxxx
Hi all,

What would be the best method of getting data from a Resultset that
has multiple joined tables?

Example

select
t1.*,
t2.*
from
table1 t1,
table1 t2
where ....

The issue is that in SQL, I can distinguish between fields of t1 and
t2 although they have the same name. In JDBC I get an error.

I can't write:

Resultset.getString("t1.field1")
and
Resultset.getString("t2.field1")
Resultset just cannot distinguish the 2 fields by the "t1." qualifier.

I know I can work around with
Resultset.getString(columnIndex).

But that does not answer my question.

Many thanks

Bernard


.