0 Replies Latest reply on Jan 15, 2009 1:18 AM by ravi krishna muthireddy

    ejb3.0 join problem

    ravi krishna muthireddy Newbie

      Hi ,

      I am new to ejb3.0. i am having a problem with join queries.

      i am having two entities 1.project 2. skills.

      project---->skills is many---to----many mapping.

      i am associating multiple skills to a project.

      my query ---> select distinct(p) from Project p join p.skills s . working fine if projects having different skills.

      if two projects having same skills .it is not bringing those projects.

      can anybody suggest what is the mistake in my query.