You can do it without a join:

SELECT DISTINCT ID, DESC, MAX(DATE) As Max_Date

FROM Table

WHERE DATE <= Getdate()

GROUP BY ID, DESC