Re: exclusion query

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,