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.
