Ed Leafe wrote: > On Mar 4, 2008, at 7:57 AM, Nate Lowrie wrote: > >> I thought we could do "Left Outer", "Right Inner", etc. as well? > > You can do whatever your backend supports. The code that creates the > SQL looks like: > > clause = "%(joinType)s join %(tbl)s on %(joinCondition)s" % locals() > > So if you set the joinType to 'Left Inner', as long as your database > understands statements like: > > ...from firstTable Left Inner join secondTable on ... > > you'll be fine.
And this is why I worded it the way I did: "Examples: 'LEFT', 'RIGHT'...". Maybe I should mention the "whatever your backend supports" part though... Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
