hi

i have a schema table like that

table_a
----------
id
name

table_b
-------
id
name
id_table_a_fk
id_table_c_fk

table_c
--------
id
name

table_a can have one or more table_b
and table b have one table_c

i have a query with a couple of inner join

so the query can return something like

i can use 3 querys and do some loop, but surely there is a better way?

queryForList could be nice, but surely i could have problem... i have some field in different table who have the same name (id, name..)

what is the best way to get the result?

thanks