[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
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
More information about the jboss-user
mailing list