Re: [SQL] Problems with HAVING

[Kaloyan Iliev Iliev]

Thanks for the replay first.
Yes I use "having" like I have written. I can't use your query because 
in subquery I must write again the whole WHERE clause.
But in the other mail in the tread there is the solution:)

Thanks again
Kaloyan
Sam Mason wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]