GROUP BY issue

From: "Jure Kodzoman (Dhimahi)" <jure(dot)kodzoman(at)dhimahi(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: GROUP BY issue
Date: 2006-04-05 11:23:38
Message-ID: 1144236218.5303.5.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hy list.

I have 3 tables:

performance
event
pool_performance

each event has it's performances, and can be assigned to one or more
pools.

pool_performance holds performance_id, pool_id and from_date

performance has event_id and performance_id as primary key

what I want to do is

select min(pool_performance.from_date), pool_id, event_id group by
performance_id

but done in a way that I group only performances belonging to the same
event but for the same pool, and not all performances.

Thanks in advance,

Jure

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2006-04-05 14:36:46 Re: have you feel anything when you read this ?
Previous Message Eugene E. 2006-04-05 06:34:54 Re: have you feel anything when you read this ?