KNOWLEDGE BASE

Unable to Create a Full Outer Join Across Different Databases


Published: 22 Aug 2016
Last Modified Date: 27 Jun 2018

Issue

Unable to create a full outer join using the cross-database join feature.

Environment

Tableau Desktop 10.1 and later versions

Resolution

Ensure that all of the data sources in the connection support full outer joins.

Cause

All of the data sources in the connection must support the full outer join type for a full outer join to be available.

Additional Information

If 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.
Did this article resolve the issue?