hello,
say i have two table, "countries" and "country groups":

countries:
country id, char, 2
country group, char 2,
name, char 10

country groups:
country group id, char, 2
name, char 10

i use this sql query:
select * from "countries" inner join "country groups" on "countries"."country group"="country groups"."country group id"

and then I execute the query and store the result in a variable rs (ResultSet),
now, i want to produce the list like this in java (according to the ResultSet)

country id, "countries"."country id"
country group, "countries"."country group"
name, "countries"."name"
country group id, "country groups"."country group id"
name, "country groups"."name"

please help,
faizal