Sortering af fataset udvalgt med DISTINCT?

Jeg har følgende SQL query :

SQL = "SELECT DISTINCT cid FROM ps_ordre WHERE levid=" & CDBl(session("lev_id"))

Jeg ønsker at sortere dette dataset efter kolonnen dato : SQL = "SELECT DISTINCT cid FROM ps_ordre WHERE levid=" & CDBl(session("lev_id")) & " ORDER BY dato DESC"

Men dette giver fejlen : "Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified." I IE.

Jeg bruger SQL Server 2000.