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

Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2012/09/28 19:21:08 UTC

[jira] [Updated] (DERBY-4832) Support for FULL OUTER JOIN

     [ https://issues.apache.org/jira/browse/DERBY-4832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor updated DERBY-4832:
-----------------------------------

    Urgency: Normal
     Labels: derby_triage10_10 gsoc gsoc2011  (was: gsoc gsoc2011)
    
> Support for FULL OUTER JOIN
> ---------------------------
>
>                 Key: DERBY-4832
>                 URL: https://issues.apache.org/jira/browse/DERBY-4832
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.6.1.0
>            Reporter: Uriah Eisenstein
>              Labels: derby_triage10_10, gsoc, gsoc2011
>
> Support for FULL OUTER JOIN. Among other things, this could be useful for comparing table contents or query results.
> "A full outer join B" can of course be achieved using "(A left join B) union (B right join A)", but the former would not only be shorter and more legible, but also possible to optimize in certain circumstances.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira