how can I create a select like this with the example class (java 2 or java 5 generator set)?

select *
from table
where field1 <> ?
and (field2 is not null or field3 is not null or field4 is not null)

I'm unable to group the 3 or clause under 1 and clause, is it possible?

thanks for the help

Emiliano Armellin
Get Firefox!
Get Thunderbird