Hi all,
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?
Thanks for all your help.
--Ray.
--------------------------------------
Raymond O'Donnell
rod(at)iol(dot)ie
rod(at)gti(dot)ie
--------------------------------------