Join

A join is an object that creates a relationship between a business component and a table that is not the base table of the business component. A join allows the business component to use fields by using columns from the joined table. To get rows on a one-to-one basis from the joined table, the join uses a foreign key in the business component even though a one-to-one relationship between the two is not required. For more information, see About Joins.