"david morgan" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly