X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D9EAE475C9E
	for <pgsql-sql@postgresql.org>; Tue, 25 Feb 2003 18:32:07 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 18259-07 for <pgsql-sql@postgresql.org>;
	Tue, 25 Feb 2003 18:31:55 -0500 (EST)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by postgresql.org (Postfix) with ESMTP id 72F6C475C60
	for <pgsql-sql@postgresql.org>; Tue, 25 Feb 2003 18:06:39 -0500 (EST)
Received: from [216.135.165.74] (account <josh@agliodbs.com>)
	by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2)
	with HTTP id 2857279; Tue, 25 Feb 2003 15:06:35 -0800
From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: Help with query involving aggregation and joining.
To: vampyre5@yahoo.com, pgsql-sql@postgresql.org
X-Mailer: CommuniGate Pro Web Mailer v.4.0.2
Date: Tue, 25 Feb 2003 15:06:35 -0800
Message-ID: <web-2857279@davinci.ethosmedia.com>
In-Reply-To: <20030225082249.44019.qmail@web80406.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200302/568
X-Sequence-Number: 11966

Eddie,

> I have not been able to get Josh suggestion to work. While tidying
> the SQL statement,
> there were some error messages that I didn't manage to solve. Josh's
> suggestion is
> probably more proper, but I will use the other alternative because
> the syntax is easier
> for me to understand.=20

Huh?  What sort of error messages?  Can you post the query you rans and
output?

-Josh