Did you, by chance, update this after you originally sent it? I could have sworn I saw a TOP 1 clause in it when I first viewed it, but now I don't see that. Perhaps I was seeing things.

>Try this - not tested
>

>Select * from Arts inner join Tasks on Arts.ArtID = Tasks.ArtID ;
>where Task.ArtID+dtos(Task.Task_Date) in ;
>(select Task.ArtID+dtos(Task.Task_Date) as TaskDate from Tasks ;
>group by ArtID order by Task_Date descending where Task = lcSpecific_Task)