Re: Having Clause with OJB

[Jakob Braeuchi]

hi reinhard,

there's no having clause in ojb so far.

jakob

Reinhard Dunst wrote:

Hi,

how can I realize this SQL statement with OJB

 select company_id 
 from companyattributes
 where attribute_id in (35,16,24) 
 group by company_id 
 having count(company_id) = 3

does anybody have an idea

thanks in advance
Reinhard
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]