Select distinct virker ikke

Hej

Ved udtræk vil jeg sørge for at et enkelt felt ikke indeholder samme tal.

Query:

SELECT DISTINCT FreightBill.OrdreNr, FreightBill.BatchId, FreightBill.prodkode, FreightBill.antkoll1, FreightBill.RegisteredTime, FreightBill.Kollinummer
FROM TransFleet.dbo.FreightBill FreightBill
WHERE (FreightBill.RegisteredTime>{ts '2002-09-30 00:00:00'} And FreightBill.RegisteredTime<{ts '2002-12-01 00:00:00'})
ORDER BY FreightBill.OrdreNr DESC

Return :

2020985    2002-11-29 20:19:26,467    02
2020985    2002-11-29 20:19:26,467    02
2020985    2002-11-29 20:19:26,467    02
2020985    2002-11-29 20:19:26,467    02

Det holder jo ikke helt !!

Nogle gode ideer ??