[Dbix-class] LEFT OUT JOIN with custom condition/bind value

Peter Rabbitson rabbit+dbic at rabbit.us
Sun Nov 25 15:20:11 GMT 2012

On Sun, Nov 25, 2012 at 11:57:28PM +0900, Hailin Hu wrote:
> Hi, Sven
> I'm afraid it is hard to define a conditional relationship with DBIx::Class.
> But you can rewrite the condition in JOIN clause with WHERE clause in
> most of cases.

An inner join - yes. A left join - never. The WHERE and ON clauses affect the
resultset quite differently in the case of a left join.

More information about the DBIx-Class mailing list