Difference between inner join and reference join.

[Former Member]

Hi,

Please can some one explain the difference between inner join and reference join.

Thanks,

Shakthi.

[Former Member]

Referential Join cannot be used if a filter is set on a field in the RIGHT table. It is semantically an inner join that assume that referential integrity is given which means that the left table always have a corresponding entry on the RIGHT table.

Referential join in Attribute View:

Referential join will work as inner join even if we don’t select columns to the output from right table.

Referential join in Analytic View:

Referential join will work as inner join if we have columns from the right table in the output.

Join will not execute if we don’t have columns from the right table in the output.