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

["David Johnston" <polobo@xxxxxxxxx>]

See embedded note after “as bld”

 

Dave

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Steve Murphy
Sent: Saturday, November 05, 2011 12:51 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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';