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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
