Announcement Announcement Module
Collapse
No announcement yet.
inner join and object Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • inner join and object

    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
Working...
X