Loading

Unable to Create a Full Outer Join Across Different Databases

Data da publicação: Apr 13, 2024
Descrição
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.
Resolução
Ensure that all of the data sources in the connection support full outer joins.
Recursos adicionais
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 do artigo do Knowledge

001472971

 
Carregando
Salesforce Help | Article