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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...