"david morgan" <david_morgan@s4c.co.uk> writes:
> I am having a few problems using a select query which joins two views
> containing aggregate functions (see query 1 below).
I don't think there's any chance of making that work in pre-7.1
Postgres. Sorry :-(.
As a workaround, consider selecting the grouped data into temp tables
and then joining the temp tables.
regards, tom lane