On Mon, Sep 22, 2008 at 09:39:08AM -0700, Mark Roberts wrote: > > Taking your second email into account, I came up with: > > select distinct pt.type_fr > from person_to_event pte > inner join person_type using (id_person_type) > where id_person_type in ( > select id_person_type > from person_to_event pte > inner join event using (id_event) > inner join event_type using (id_event_type) > where type_fr = 'theatre' > ) and id_person_type not in ( > select id_person_type > from person_to_event > where id_event = 219 > ) > > I feel like there's a solution involving group by tugging at the back of > my mind, but I can't quite put my finger on it. Sorry if this isn't > quite what you're asking for.
Hi, That works very nicely (with minor adaptations). I also had that solution-without-a-subselect in the back of my mind but this does the job just fine! Cheers, -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
