Postgres Pro
Downloads
Home   >   mailing lists

Re: Finding multiple events of the same kind - Mailing list pgsql-sql

From Leif B. Kristensen
Subject Re: Finding multiple events of the same kind
Date
Msg-id 200606111534.17393.leif@solumslekt.org
Whole thread Raw
In response to Re: Finding multiple events of the same kind  (Frank Bax <fbax@sympatico.ca>)
Responses Re: Finding multiple events of the same kind
List pgsql-sql
Tree view 
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!
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE

pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: Re: Finding multiple events of the same kind
Next
From: Richard Broersma Jr
Date:
Subject: Re: Finding multiple events of the same kind