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 "C.S. Nirmal J. Fernando (JIRA)" <ji...@apache.org> on 2011/03/04 03:56:37 UTC

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

    [ https://issues.apache.org/jira/browse/DERBY-4832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13002429#comment-13002429 ] 

C.S. Nirmal J. Fernando commented on DERBY-4832:
------------------------------------------------

This is really interesting idea!! Thanks Bryan for labeling this as GSoC. 
I am wondering whether someone willing to mentor this idea. 

Thanks. 

> 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