| From: | Binand Sethumadhavan <binand(at)gmx(dot)net> |
|---|---|
| To: | Lonni J Friedman <netllama(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: JOIN producing duplicate results |
| Date: | 2012-05-03 04:09:42 |
| Message-ID: | CAFBJCCZ5AFRKGY96gVONc_MT17da_tgEZiBx2taaRjSJ1Gogfg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 3 May 2012 05:21, Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> I've got a query that is joining data across 4 tables to provide data
> based on test results. The query is working fine, except for the fact
[snip]
This is your query formatted in my favourite SQL formatting style:
It looks OK to me, so the only reason I can think of (without knowing
the DDL etc.) is data duplication. I would suggest you remove the
joined tables one by one and see which of them is introducing the
duplication (or alternatively, start by querying only smoketests and
then add the joined tables one by one to see which one introduces the
duplication). Then explore the data in that table.
Incidentally, you are not using the table "smoke" for anything. That
would be the first table I'd remove.
Binand
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bibek Behera | 2012-05-03 11:04:33 | REGARDING ADDING A DATATYPE LIKE POLYGON |
| Previous Message | Lonni J Friedman | 2012-05-02 23:51:54 | JOIN producing duplicate results |