Loading

Unable to Create a Full Outer Join Across Different Databases

Fecha de publicación: Apr 13, 2024
Descripción
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.
Solución
Ensure that all of the data sources in the connection support full outer joins.
Recursos adicionales
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.

Número del artículo de conocimiento

001472971

 
Cargando
Salesforce Help | Article