Андрей Костенко wrote: > Has I can write in DBIx::Class this query: > > SELECT * FROM table1 LEFT JOIN table2 ON table2.table1_id=table2.id > <http://table2.id>* AND table2.user_id=123*? > > Where* user_id* is an any random number. >
For now you have to do this manually. If the user_id is static (i.e. doesn't change) use: http://search.cpan.org/~ribasushi/DBIx-Class-0.08103/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource If the join condition is dynamic use the last example at: http://search.cpan.org/~ribasushi/DBIx-Class-0.08103/lib/DBIx/Class/ResultSet.pm#from _______________________________________________ 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/dbix-class@lists.scsys.co.uk