| 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
| 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 |
| 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 |