openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pawel Veselov <pawel.vese...@gmail.com>
Subject Re: left joins, wheres and IN
Date Wed, 28 Dec 2011 17:40:19 GMT
Hi.

On Wed, Dec 28, 2011 at 7:57 AM, Pinaki Poddar <ppoddar@apache.org> wrote:

> 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})
>
>
That would of course give the results, but it's a nested loop, and over a
sub-query too. I don't believe OpenJPA (or any other JPA) would convert
that to a left join (though it should technically be possible to do so) in
any dialect.

My original concern was about true left joins.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message