Solution: Select latest entry for a group of records

[Tomasi, Chuck]

Thanks to all who responded.  The winning solution (with a few
modifications) went something like this:

select
         d1.id
        ,d1.tapeid
        ,d1.locid
        ,d1.mdate
from tape_change_log d1
where d1.mdate = (
        select max(d2.mdate)
        from tape_change_log d2
        where d2.tapeid = d1.tapeid
        group by d2.tapeid
        )
order by
         id
        ,tapeid

Thanks again

--Chuck

P.S. -confession- this was not my problem, I posted for a coworker since I
couldn't give him a direct solution.