[jboss-user] [EJB 3.0] - ejb query not in operator

mravikrish do-not-reply at jboss.com
Thu Dec 11 04:40:26 EST 2008

Hi All,

     I am Ramu , i am having a problem with the following query

  select distinct(p) from Project p  join p.projectStatus ps left outer join p.bids b left outer join b.vendors v  where ps.description like 'open'  and v.id not in(4) 

with the above query i am getting  the open projects including the project vendor(4) has bidded. 

i want the open projects which vendor has not bided

projectstatus is table
bid is table
vendor is table

Thanks Ramu

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4195841#4195841

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4195841

More information about the jboss-user mailing list