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