| 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 |
|
| View raw message | |