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
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 ? |