Attempts to infer a join condition of an indirect relationship (with a join-table).
Attempts to infer a join condition of an indirect relationship (with a join-table).
The foreign keys declared on the From table and the joining Through table will be used to infer a join condition. This will fail when:
- There are no foreign keys declared from the From table to the Through table or from the Through table to the From table. - There is more than 1 candidate foreign key (either both From and Through declare a foreign key to each other, or either of them declares more than 1 foreign key to the other). - The candidate foreign key is non-standard, that is, does not point to the other table's ID column.
The origin table type for the join.
The join-table type.
The target table type for the join.