On Fri, Nov 4, 2011 at 10:51 PM, Steve Murphy <smurphy(at)intorrent(dot)com> wrote:
> select schedule.id as sched_id, bld.id as bid
> from
> schedule
> left join company on schedule.company = company.id
> left join (select * from building where building.company =
> company.id order by id limit 1) as bld
> where
> schedule.status = 'active' and company.status = 'active' and
> bld.status = 'active';
Looks like you need an on clause after the second left join.