combining duplicated rows

Hi there,

I have a selection which brings me duplicated ID field but with different collumns data. Now I want to combine all in one row. Can anyone help ?

Ex:

[ID]------[date1]-----[date2]-----[date 3]
'10'------'23/05/04'-----null---------null
'10'---------null-----'10/02/04'------null
'10'---------null--------null-------'05/03/04'


Want it to be one row:
[ID]------[date1]-----[date2]-----[date 3]
'10'-----'23/05/04'---'10/02/04'---'05/03/04'


Thanks a lot !

SELECT
a.ID
, MAX(a.[DATE1]) AS [DATE1]
, MAX(a.[DATE2]) AS [DATE2]
, MAX(a.[DATE3]) AS [DATE3]
FROM
tbl AS a
GROUP BY
a.ID