Resolution

Try the following steps:

• If you are using custom objects, make sure that the first table in the join contains a Reference field that points to the second table.

  For example, make sure Table A has a field of type Reference('B').

• If you are using an inner join, try reversing the order.

  For example, instead of joining Table A to Table B, try joining Tableau B to Table A.

• If you are using a left join, or if neither of the previous steps were successful, use data blending instead.

Cause

Table ("Object" in Salesforce terminology) relationships are predefined in Salesforce. To join two tables, the first table must contain a Reference field that points to the second table. The two tables must have an established primary key/foreign key relationship. The foreign key is the Reference field of the first table, and the primary key is the ID field of the second table.

Additional information

For more information, see the following topics in the Salesforce Administrator and API documentation.

• Overview of Object Relationships
• Field Types