| 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: | Whole Thread | Raw Message | 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 ? |