Kaloyan Iliev Iliev wrote:
>select test.name
>from test
>where test.name = foo.name
>having max(test.date)
I don't think you use the "having" clause like you've done there. I
think you want to be doing something more like:
select test.name from test where test.name = foo.name and test.date in (select max(date) from test);
But I may have misinterpreted you. . .
Cheers, Sam