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

[Peter Rabbitson]

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.