Re: JOIN - Mailing list pgsql-sql

From Gregory Stark
Subject Re: JOIN
Date
Msg-id 87ps4ad0yo.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: JOIN  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
List pgsql-sql
"Loredana Curugiu" <loredana.curugiu@gmail.com> writes:

> I am trying to say that sum column it is not calculated correctly.

It looks like your counts are high. That would imply that your join clauses
are matching more than one combination of rows. Ie, it's counting some rows
multiple times because there are multiple join matches.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: JOIN
Next
From: "Loredana Curugiu"
Date:
Subject: JOIN