Help with join and distinct query

Hi. I am not that experienced with sql queries so I might be missing something obvious here. My problem is that the query returns a lot of duplicates. This probably occurs because I do three joins, but I try to remedy this with both GROUP BY and DISTINCT. Strangely enough, they do not change the output from the query at all.

My troublesome query is the following:

SELECT DISTINCT KUNDE.NAVN,AVL_TELLEVERK.AVLEST_TIDSPKT FROM KUNDE,ABONNEMENT,BETALER,AVL_TELLEVERK WHERE (KUNDE.KUNDE_ID=ABONNEMENT.KUNDE_ID AND ABONNEMENT.MAALER_ID=AVL_TELLEVERK.MAALERID AND ABONNEMENT.KUNDE_ID=BETALER.KUNDE_ID AND BETALER.NAVN='Bedrift' AND KUNDE.NAVN='kunde')
GROUP BY KUNDE.NAVN,AVL_TELLEVERK.AVLEST_TIDSPKT Any help would be much appreciated.

Thanks
Haavard Futsaeter Received on Wed Jul 31 2002 - 15:51:39 CEST