openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daryl Stultz <da...@6degrees.com>
Subject Re: Left join with multiple criteria
Date Fri, 11 Sep 2009 19:20:26 GMT
On Fri, Sep 11, 2009 at 2:55 PM, Luis Fernando Planella Gonzalez <
lfpg.dev@gmail.com> wrote:

>
> I'm not 100% sure, but I think this should work:
>
> select a, c
> from A as a
> left join a.cs as c
> where a.p1 = 2
> and (c.id is null or c.p1 = 3)
>
>
As per my first post, I tried that. I still believe it should work, but it
doesn't.

-- 
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
mailto:daryl@6degrees.com

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