Tsql - Avoid Repeated Rows

Hi Guys,


I am using the query below to retrieve these results:
You can see that the results are repeated, once for DATIF = 1 and then again for DATIF = 2.
In this case does not matter if the results appear close to DATIF 1 or DATIF 2.
Take in care that I can not know how may extradates or Extrasums are attached to each Account.

Is there any way to avoid these repeated rows?
Thanks in advance,
Aldo.


ACCOUNTKEY DATFID DATFNAME DATF SUFID SUFNAME SUF

--------------- ----------- -------------------------------------------------- ----------------------- ----------- -------------------------------------------------- ----------------------

123456 1 ExtraDates01 2005-01-01 00:00:00.000 1 ExtraSum01 4

123456 1 ExtraDates01 2005-01-01 00:00:00.000 2 ExtraSum02 3

123456 1 ExtraDates01 2005-01-01 00:00:00.000 3 ExtraSum03 1

123456 1 ExtraDates01 2005-01-01 00:00:00.000 4 ExtraSum04 2

123456 2 ExtraDates02 2004-01-01 00:00:00.000 1 ExtraSum01 4

123456 2 ExtraDates02 2004-01-01 00:00:00.000 2 ExtraSum02 3

123456 2 ExtraDates02 2004-01-01 00:00:00.000 3 ExtraSum03 1

123456 2 ExtraDates02 2004-01-01 00:00:00.000 4 ExtraSum04 2



Code Snippet
SELECT DISTINCT

Accounts.ACCOUNTKEY,

ExtraDates.DATFID,

ExtraDateNames.DATFNAME ,

ExtraDates.DATF ,

ExtraSums.SUFID ,

ExtraSumNames.SUFNAME ,

ExtraSums.SUF
FROM
EXTRADATES AS ExtraDates
LEFT OUTER JOIN EXTRADATENAMES AS ExtraDateNames ON ExtraDates.DATFID = ExtraDateNames.DATFID
RIGHT OUTER JOIN ACCOUNTS AS Accounts ON ExtraDates.KEF = Accounts.ACCOUNTKEY
LEFT OUTER JOIN EXTRASUMS AS ExtraSums
LEFT OUTER JOIN EXTRASUMNAMES AS ExtraSumNames ON ExtraSums.SUFID = ExtraSumNames.SUFID ON Accounts.ACCOUNTKEY = ExtraSums.KEF
LEFT OUTER JOIN EXTRANOTENAMES
RIGHT OUTER JOIN EXTRANOTES ON EXTRANOTENAMES.NOTEID = EXTRANOTES.NOTEID ON Accounts.ACCOUNTKEY = EXTRANOTES.KEF
WHERE
Accounts.SORTGROUP BETWEEN 0 AND 999999999
AND Accounts.ACCOUNTKEY BETWEEN '123456' AND '123456'