[Dbix-class] Handling Multiple join

[linuxsupport]

Hi all,

If I join multiple tables and one of the table contains more than 1 row and
all records appear in more than 1 row.

for example, table1 has id and create_date, table2 has author_name, table3
has gorup_name and these can return only one row for a given id, but table4
can have more than 1 record for given id ( id from table1 refers in every
tables), so it return like

id     |   create_date   | author_name    | group_name | comment_id
1      |    2010-12-26   | name1             | group1          | 1
1      |    2010-12-26   | name1             | group1          | 2 -- more
than 1 comment_id for id -> 1

Is there a way to tell search query to store the results of column
commnet_id into another list or array? otherwise how to handle it?

Many thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20101230/def=
1785a/attachment.htm