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

[mravikrish]

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
 
relationships
 
project--->projectstatus
 
project----->bid
 
bid------>vendor
 

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