openjpa-users mailing list archives

Site index · List index
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