db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C.S. Nirmal J. Fernando (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4832) Support for FULL OUTER JOIN
Date Fri, 04 Mar 2011 03:00:37 GMT

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

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

Whoops ! I just noticed that Lahiru showed his interest about this idea!

> 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:
>            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


View raw message