Re: What is *wrong* with this query???

See embedded note after “as bld”

Dave

I give! I'm flummoxed!

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  ****** <-- LEFT JOIN  “ON WHAT?”

    where

        schedule.status = 'active' and company.status = 'active' and bld.status = 'active';