[Dbix-class] Left join with an extra condition

Bill Moseley moseley at hank.org
Fri Oct 23 19:45:01 GMT 2009


Looking for how to add an addition condition on a join.  Here's an example
of the query with the extra condition in CAPS

select u.* <http://p.id/>, count(o.id)
from user u
left outer join job j on   j.user =3D u.id AND J.JOB_TYPE =3D 6
where u.location  =3D ?
group by u.*

So, wondering how to represent that along with the extra join condition.

Thanks,

-- =

Bill Moseley
moseley at hank.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20091023/c2a=
c2857/attachment.htm


More information about the DBIx-Class mailing list