Last Modified Date: 25 Jan 2019
ResolutionEnsure that all of the data sources in the connection support full outer joins.
CauseAll of the data sources in the connection must support the full outer join type for a full outer join to be available.
Additional InformationIf a database which does not support full outer joins is added to the connection, the full outer join will not work, whether or not a specific table from that database is added.
For example, a full outer join between a MS SQL table and an Oracle table will work. However, when a connection to a MySQL database is added, then the full outer join will become invalid, even though the full outer join does not include a specific table from the MySQL database.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials