Unable to Create a Full Outer Join Across Different Databases

Published: 22 Aug 2016
Last Modified Date: 10 Sep 2020


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


  • Tableau Desktop 


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


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.

Discuss this article... Feedback Forum
Did this article resolve the issue?