Loading

Unable to Create a Full Outer Join Across Different Databases

Julkaisupäivä: Apr 13, 2024
Kuvaus
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.
Ratkaisu
Ensure that all of the data sources in the connection support full outer joins.
Lisäresurssit
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-artikkelin numero

001472971

 
Ladataan
Salesforce Help | Article