InnerJoin в подчиненом датасорсе на форме

[oip]

Цитата:

Passive
Linked child data sources are not updated automatically. Updates of the child data source must be programmed on the active() method of the master data source.

Delayed
A pause is inserted before linked child data sources are updated. This allows for faster navigation in the parent data source since the records from child data sources are not updated immediately. For example, the user could be scrolling past several orders without immediately seeing the order lines for each one.

Active
The child data source is updated immediately when a new record in the parent data source is selected. Notice that continuous updates are resource-consuming.

InnerJoin
Selects records from the main table that have matching records in the joined table – and vice versa.
In other words, you get one record for each match and records without related records are eliminated from the result.

OuterJoin
Selects records from the main table whether or not they have matching records in the joined table.

ExistJoin
Selects a record from the main table for each matching record in the joined table.

The difference between InnerJoin and ExistJoin:

When the join type is ExistJoin, no more potentially matching records are searched for once the first match has been found.
When the join type is InnerJoin, all matching records are searched for.

NotExistJoin
Select records from the main table that do not have a match in the joined table.

Development Guide