From: Leif B. Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Finding multiple events of the same kind
Date: Sun, 11 Jun 2006 15:34:17 +0200
Message-ID: <200606111534.17393.leif@solumslekt.org> (raw)
In-Reply-To: <5.2.1.1.0.20060611092112.04a773f0@pop6.sympatico.ca>
References: <5.2.1.1.0.20060611092112.04a773f0@pop6.sympatico.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: leif@solumslekt.org
Subject: Re: Finding multiple events of the same kind
In-Reply-To: <200606111534.17393.leif@solumslekt.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox