First page Back Continue Last page Graphics

Creating a Join View Object


Notes:

Creating a Join View Object

A join view object is one that is based upon multiple entity objects that are related by one or more associations. When you create a join view object, you can select from the following join types:

Inner join (default): Rows that meet query criteria are returned only if related rows exist in both entities. For example, only Person rows with at least one order and only Orders rows that are associated with a person are returned.

Left outer join: All rows that meet the criteria from the first entity object are returned by the query, regardless of whether there are rows in the second entity. For example, all Person rows that meet query criteria are returned, regardless of whether they have an associated order.

Right outer join: All rows that meet the criteria from the second entity object are returned by the query, regardless of whether there are rows in the first entity. For example, all Order rows that meet query criteria are returned, regardless of whether they have an associated person.