brew <brewsterb...@gmail.com> writes: > Hi, > > Anyone know of native support queries like: > > SELECT * FROM artist a LEFT JOIN cd c *ON a.name = c.artist AND c.year = > 2000* > > Note the complex on clause.
Yes, this is now supported by custom join conditions, which give you the full power of SQLA to build your ON clause. See the bit about "custom join condition coderef syntax" in: https://metacpan.org/module/DBIx::Class::Relationship::Base#condition -- - Twitter seems more influential [than blogs] in the 'gets reported in the mainstream press' sense at least. - Matt McLeod - That'd be because the content of a tweet is easier to condense down to a mainstream media article. - Calle Dybedahl _______________________________________________ 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