> This is what I want to do with the data table below.
>
> I only want it to show one id for each issue. ( ie, 4001 only once,
> 4002 only once, etc. But only the one with the latest date and time)
>
> Ie. 4001 should only be in the table once, with the latest date -
> which should be :
> 4001 09/12/2003 17:12:09 (as I only want to show the last time
> the id was updated - do you get me now )
>
> Ie. 4002 should show only 4002 11/12/2003 15:25:13
>

>
>
> id hs_change_date hs_change_time
> 4001 27/10/2003 10:38:27
> 4001 09/12/2003 14:43:58
> 4001 09/12/2003 17:12:09
> 4002 27/10/2003 10:56:28
> 4002 09/12/2003 14:44:11
> 4002 11/12/2003 15:25:13
> 4003 27/10/2003 11:13:12
> 4003 09/12/2003 14:44:21
> 4003 10/12/2003 10:48:02
> 4003 10/12/2003 13:25:09
> 4004 27/10/2003 11:28:09
> 4004 09/12/2003 14:44:29
> 4004 09/12/2003 17:18:28
> 4005 27/10/2003 15:55:40
> 4005 28/10/2003 10:18:24
> 4006 27/10/2003 15:59:47
> 4006 28/10/2003 10:18:38
> 4006 09/12/2003 14:44:40
> 4006 09/12/2003 16:47:15
>