r937 wrote: > the way to solve this is to get a derived table which tells you the max > timestamp for each group, and join that back to the table > > Thanks rudy, I found a similar solution and didn't know whether it was more effort than necessary, but your explanation clarifies everything, thanks! Joe