[Dbix-class] LEFT OUT JOIN with custom condition/bind value
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