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
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
