Join

A Join object definition creates a relationship between a business component and a table other than its base table.

This relationship allows the business component to use columns from the other table. The join uses a foreign key in the business component to obtain rows on a one-to-one basis from the joined table, even though the two tables do not necessarily have a one-to-one relationship.

Join have 1:1 and Many:1 RelationShip.