Hello,

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