Re: JOIN

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, <pgsql-novice(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: JOIN
Date: 2007-06-05 12:45:19
Message-ID: 87ps4ad0yo.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

"Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Loredana Curugiu 2007-06-05 12:59:04 Re: [SQL] JOIN
Previous Message Richard Huxton 2007-06-05 12:39:29 Re: JOIN

Browse pgsql-sql by date

  From Date Subject
Next Message Loredana Curugiu 2007-06-05 12:59:04 Re: [SQL] JOIN
Previous Message Richard Huxton 2007-06-05 12:39:29 Re: JOIN