Re: SQL question - duplicate records from join

Hi folks,

I sent the attached email a few days ago, and if anyone can help me
I'd be really appreciative - I'm no SQL guru and this one has me
stumped! If this is the wrong forum for this message please do
redirect me.

--Ray.

On 28 Feb 2002 at 18:46, Raymond O'Donnell wrote:

> I recently upgraded to Postgres 7.1 (having finally found the correct
> pg_dump!), and now I notice that joins are returning duplicate
> records. A typical query would be:
>
> select i.itemcode, i.itemname, d.deptname, r.roomname
> from items i
> inner join departments d on (i.deptcode=d.deptcode)
> inner join rooms r on (i.roomcode=r.roomcode)
> where... (etc)
>
> This query returns four copies of each record, where before I just got
> one as I'd expect. Am I doing something wrong here?

---------------------------------------------------------
Raymond O'Donnell http://www.iol.ie/~rod/organ
rod(at)iol(dot)ie The Irish Pipe Organ Page
---------------------------------------------------------