help me

Dear All,

how to select row in java

I have 2 table

1) select t.din, t.name from debitur t
__________
DIN | NAME
—————–
001 James
001 John
—————–

select t.din, t.nilai from transaksi t
_________
DIN | NILAI
—————–
001 9500
001 7500
001 8000
—————-

Results to be:
_________________
DIN | NAME | NILAI
—————————---
001 James 9500
001 John 7500
001 8000
—————————



Thanks & Regards
Ridwan

Based upon what you posted this seems more an SQL question than a java specific question. To select across tables, you can use primary and foreign keys along with the JOIN keyword. As is, the tables look a bit confusing to achieve what you wish to achieve easily without knowing more about the database organization. You can try to organize it post-query using some arrays and such. Without any more information and code that's about all one can recommend.