Loading

Unable to Create a Full Outer Join Across Different Databases

Date de publication: Apr 13, 2024
Description
Unable to create a full outer join using the cross-database join feature.

Cause

All of the data sources in the connection must support the full outer join type for a full outer join to be available.
Résolution
Ensure that all of the data sources in the connection support full outer joins.
Ressources supplémentaires
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.

Numéro d’article de la base de connaissances

001472971

 
Chargement
Salesforce Help | Article