Last Modified Date: 27 Jul 2018
- Tableau Desktop
- If in 8.2 or later, connect to the data using a legacy connection. If in 8.1 or earlier, connect as usual.
- Write custom SQL for a UNION of a LEFT and RIGHT join.
Option 2Mirror the data to a database that supports a Full Outer join, such as MS SQL.
CauseWhen connecting to data on a Microsoft Access database, the outer join is not available due to limitations in the Microsoft Access database.
Additional InformationJoin tables and queries in Microsoft Office Support
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials