Loading

Unable to Create a Full Outer Join Across Different Databases

Publiceringsdatum: Apr 13, 2024
Beskrivning
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.
Lösning
Ensure that all of the data sources in the connection support full outer joins.
Ytterligare resurser
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.

Knowledge-artikelnummer

001472971

 
Laddar
Salesforce Help | Article