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