Re: SQL question - duplicate records from join
От | Raymond O'Donnell |
---|---|
Тема | Re: SQL question - duplicate records from join |
Дата | |
Msg-id | 3C836DED.7183.62A787@localhost обсуждение исходный текст |
Ответ на | SQL question - duplicate records from join ("Raymond O'Donnell" <rod@iol.ie>) |
Ответы |
Re: SQL question - duplicate records from join
Re: SQL question - duplicate records from join |
Список | pgsql-general |
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@iol.ie The Irish Pipe Organ Page ---------------------------------------------------------
В списке pgsql-general по дате отправления: