[Dbix-class] Can I get help composing a query?

[Rob Kinyon]

On Fri, Apr 24, 2009 at 15:12, Dennis Daupert <ddaupert at gmail.com> wrote:
> I've worked out the SQL that gives me the results I need,
> at least at the database level:
>
> SELECT *
> FROM docs
> LEFT JOIN files
> ON docs.id = files.doc_id
> WHERE docs.project_id = 94
> AND files.id IN ( '2036', '2033' );

Your relationships are wrong. Fix them and you're good.

-- 
Thanks,
Rob Kinyon