| Message view | « Date » · « Thread » |
|---|---|
| Top | « Date » · « Thread » |
| From | Pinaki Poddar <ppod...@apache.org> |
| Subject | Re: left joins, wheres and IN |
| Date | Wed, 28 Dec 2011 15:57:29 GMT |
How about
select a from Alpha a
where {predicates on a}
and not exists (select b from Beta b where b.alpha = a and
{other predicates on b})
-----
Pinaki Poddar
Chair, Apache OpenJPA Project
--
View this message in context: http://openjpa.208410.n2.nabble.com/left-joins-wheres-and-IN-tp7131885p7133073.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
| |
| Mime |
|
| View raw message | |