openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pinaki Poddar <>
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:
Sent from the OpenJPA Users mailing list archive at

View raw message