Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8077C7277 for ; Thu, 20 Oct 2011 06:58:04 +0000 (UTC) Received: (qmail 48800 invoked by uid 500); 20 Oct 2011 06:58:04 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 48748 invoked by uid 500); 20 Oct 2011 06:58:04 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 48741 invoked by uid 99); 20 Oct 2011 06:58:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Oct 2011 06:58:03 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [141.146.126.227] (HELO acsinet15.oracle.com) (141.146.126.227) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Oct 2011 06:57:53 +0000 Received: from ucsinet21.oracle.com (ucsinet21.oracle.com [156.151.31.93]) by acsinet15.oracle.com (Switch-3.4.4/Switch-3.4.4) with ESMTP id p9K6vT98024727 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Thu, 20 Oct 2011 06:57:31 GMT Received: from acsmt356.oracle.com (acsmt356.oracle.com [141.146.40.156]) by ucsinet21.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id p9K6nSYl015827 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 20 Oct 2011 06:49:29 GMT Received: from abhmt108.oracle.com (abhmt108.oracle.com [141.146.116.60]) by acsmt356.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id p9K6vNeQ004441 for ; Thu, 20 Oct 2011 01:57:23 -0500 Received: from localhost (/10.175.29.227) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Wed, 19 Oct 2011 23:57:22 -0700 From: Knut Anders Hatlen To: "Derby Discussion" Subject: Re: Derby compatibility with Oracle syntax for outer joins References: Date: Thu, 20 Oct 2011 08:57:20 +0200 In-Reply-To: (Ross Harman's message of "Wed, 19 Oct 2011 16:11:30 -0700") Message-ID: User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (usg-unix-v) MIME-Version: 1.0 Content-Type: text/plain X-Source-IP: ucsinet21.oracle.com [156.151.31.93] X-CT-RefId: str=0001.0A090201.4E9FC65B.015E,ss=1,re=0.000,fgs=0 X-Virus-Checked: Checked by ClamAV on apache.org Ross Harman 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