Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 86241 invoked from network); 5 Oct 2010 14:49:42 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 5 Oct 2010 14:49:42 -0000 Received: (qmail 73011 invoked by uid 500); 5 Oct 2010 14:49:42 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 72817 invoked by uid 500); 5 Oct 2010 14:49:40 -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 72810 invoked by uid 99); 5 Oct 2010 14:49:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Oct 2010 14:49:39 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=10.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 [148.87.113.121] (HELO rcsinet10.oracle.com) (148.87.113.121) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Oct 2010 14:49:29 +0000 Received: from acsinet15.oracle.com (acsinet15.oracle.com [141.146.126.227]) by rcsinet10.oracle.com (Switch-3.4.2/Switch-3.4.2) with ESMTP id o95En6u7029746 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Tue, 5 Oct 2010 14:49:08 GMT Received: from acsmt353.oracle.com (acsmt353.oracle.com [141.146.40.153]) by acsinet15.oracle.com (Switch-3.4.2/Switch-3.4.1) with ESMTP id o95AMqFB007517 for ; Tue, 5 Oct 2010 14:49:00 GMT Received: from abhmt006.oracle.com by acsmt354.oracle.com with ESMTP id 663912961286290137; Tue, 05 Oct 2010 07:48:57 -0700 Received: from localhost (/129.159.112.235) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Tue, 05 Oct 2010 07:48:56 -0700 From: dag.wanvik@oracle.com (Dag H. Wanvik) To: Derby Discussion Subject: Re: Any plans for implementing full outer joins? References: Date: Tue, 05 Oct 2010 16:48:52 +0200 In-Reply-To: (Uriah Eisenstein's message of "Sat, 02 Oct 2010 13:05:44 +0200") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (usg-unix-v) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked by ClamAV on apache.org Uriah Eisenstein writes: > I've searched the mailing list and JIRA but didn't find any mention of full > joins. I realize that they can be implemented using unions of left and right > joins and such, but IMHO are easier to read and write as well as quite > possibly more efficient. There are no current efforts underway to support full outer joins as far as I know. Feel free to file an improvement JIRA issue, so people can vote for it. Dag