Re: Finding multiple events of the same kind

From: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Finding multiple events of the same kind
Date: 2006-06-11 13:34:17
Message-ID: 200606111534.17393.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2006-06-11 18:36:39 Re: Finding multiple events of the same kind
Previous Message Frank Bax 2006-06-11 13:27:12 Re: Finding multiple events of the same kind