Re: SQL question - duplicate records from join

Are you sure that the data in your new installation is
really the same as in the old, i.e. your data did not
get loaded twice??

--- Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> 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
>
---------------------------------------------------------
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org
> so that your
> message can get through to the mailing list cleanly

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com