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

See embedded note after “as bld”

Dave

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Steve Murphy
Sent: Saturday, November 05, 2011 12:51 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] What is *wrong* with this query???

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';