Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

left join in JPA namedquery

 
Rajeev Ravindran
Ranch Hand
Posts: 455
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi,
Im trying to include "left Join" in the query below its errors out

this query works
" select j from Job j, IN (j.contactsList) cnts where cnts.job.id = j.id and req.job.id = j.id and j.creatorUID = :creatorId order by j.id desc "

what Im trying is to left join the above query with another table

" select j from Job j, IN (j.contactsList) cnts , LEFT JOIN (j.paramValuesList) pval where cnts.job.id = j.id and req.job.id = j.id and j.creatorUID = :creatorId order by j.id desc "


Job class has the following relation to paramValuesList
@OneToMany(mappedBy = "job", cascade={CascadeType.ALL})
private List<ParamValues> paramValuesList;

Is it possible to have both IN and LEFT JOIN in the same query ? I was looking at various examples i found online, if someone can correct me the syntax it will be great.

thanks,

- rajeev



 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic