0 Replies Latest reply on Dec 11, 2008 4:40 AM by ravi krishna muthireddy

    ejb query not in operator

    ravi krishna muthireddy Newbie


      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