Skip site navigation (1) Skip section navigation (2)

Re: JOIN producing duplicate results

From: Binand Sethumadhavan <binand(at)gmx(dot)net>
To: Lonni J Friedman <netllama(at)gmail(dot)com>
Cc: "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>, Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: JOIN producing duplicate results
Date: 2012-05-04 03:02:26
Message-ID: CAFBJCCbD-KDe3mUY9ofm-8kjy_ty=Vn+_vYjWT2tfhn4y8rngg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 3 May 2012 22:34, Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
>     o.arch=a.arch AND a.osversion = o.osversion

Note that if you need to do this, it is almost always an indicator of
a problem in your ER model.

Binand

In response to

pgsql-novice by date

Next:From: Marta Pérez RomeroDate: 2012-05-04 09:43:12
Subject: Query to get the min of the total
Previous:From: Lonni J FriedmanDate: 2012-05-03 17:04:05
Subject: Re: JOIN producing duplicate results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group