> On Sunday 11. June 2006 15:27, Frank Bax wrote:
> >SELECT participants.person_fk, count(participants.person_fk) FROM
> > events, participants
> > WHERE events.event_id = participants.event_fk
> > AND events.tag_fk in (2,62,1035)
> > GROUP BY participants.person_fk HAVING
> > count(participants.person_fk) > 1
>
> That worked like a charm! Thank you very much!
> --
Also, you could create a unique column constraint that would prevent multiply instances of the
same person in the participants table.
Regards,
Richard Broersma Jr.