You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Ross Harman <ro...@hotmail.com> on 2011/10/20 01:11:30 UTC

Derby compatibility with Oracle syntax for outer joins

Does Derby support the Oracle (+) notation for outer joins?

Re: Derby compatibility with Oracle syntax for outer joins

Posted by Knut Anders Hatlen <kn...@oracle.com>.

Ross Harman <ro...@hotmail.com> writes:

> Does Derby support the Oracle (+) notation for outer joins?

No, Derby only supports the LEFT OUTER JOIN and RIGHT OUTER JOIN syntax
for outer joins.

http://db.apache.org/derby/docs/10.8/ref/rrefsqlj29840.html

-- 
Knut Anders