How to setup join relation with AND clause on a JOIN?

[Blastiko]

Hi all.

In model cfc, how can i setup a relation like this?

SELECT tt.id

FROM tTable tt

LEFT JOIN aTable at ON at.fk_id = tt.id AND at.active = 1

In aTable.cfc model i can write this:
hasMany(name="rel_name", modelName="tTable", foreingKey="fk_id", joinType="outer");

but how can i setup the last part: "... AND at.active = 1" ?

Thanks

[Tom King]

Not sure wheels deals wheel with table aliases.

But you should be able to do it without?  

T

[Blastiko]

Hi Tom

Yeah, i used workaround, less elegant and more expensive but works.

Thanks.