Specifying the Join Condition for a Master-Detail Relation
You can specify a join condition with the following entries:
- an item name that exists in both the master block and the detail block (do
not preface the item names with colons)
- an equating condition of two item names, where one item exists in the master
block and the other exists in the detail block
- a combination of item names and equating conditions
The following are valid join conditions:
- an item name that occurs in both blocks:
ordid
- an equating condition:
:warehouse.region_id = :region.id
- compound joins can be entered in the following format:
:block1.item1 = :block2.item1 AND :block1.item2 = :block2.item2
Note: The primary-foreign key relationship between
the database tables can be a purely logical one. Explicit primary-key or foreign-key
column constraints in the relevant tables and columns are not required.
Related topic
Join Condition Property