[Dbix-class] JOIN question

[Matt S Trout]

Bernhard Graf wrote:
> Matt S Trout wrote:
> 
>>> SELECT me.title
>>> FROM email me
>>> LEFT JOIN chunk chunks ON chunks.email=me.id
>>> LEFT JOIN chunk chunks_2 ON chunks_2.email=me.id AND chunks.id!=chunks_2.id
>> why not just join => [ qw/chunks chunks/ ] and add { 'chunks.id' =>
>> \"!= chunks_2.id" } to the where?
> 
> Thanks for the answer, but this must be in the JOIN ... (ON ...) part to
> work correctly.

Why?