Re: Problems with HAVING

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