Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2D4LFx38173 for ; Mon, 12 Mar 2001 23:21:15 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2D4Ktt17922; Mon, 12 Mar 2001 23:20:55 -0500 (EST) To: "david morgan" cc: pgsql-sql@postgresql.org Subject: Re: error joining 2 views containing GROUP BYs In-reply-to: <98aine$ql6$1@news.tht.net> References: <98aine$ql6$1@news.tht.net> Comments: In-reply-to "david morgan" message dated "Fri, 09 Mar 2001 12:36:08 +0000" Date: Mon, 12 Mar 2001 23:20:55 -0500 Message-ID: <17919.984457255@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/247 X-Sequence-Number: 1906 "david morgan" 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