db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4832) Support for FULL OUTER JOIN
Date Fri, 04 Mar 2011 02:48:36 GMT

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

Bryan Pendleton updated DERBY-4832:
-----------------------------------

    Labels: gsoc  (was: )

> 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: gsoc
>
> 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message