Bookshelf Home | Contents | Index | Search | PDF

Configuration Guidelines > Creating and Modifying Objects > Constructing Joins >

Creating Implicit Joins

---

Implicit joins have the following properties:

You do not have to define an implicit join through Siebel Tools. These joins exist for all 1:1 (_X) extension tables and relevant intersection tables.
Implicit joins exist for party related entities. There is an implicit join available for each extension table belonging to a base table. S_PARTY has many extension tables, including S_ORG_EXT, S_CONTACT, S_POSTN, and S_USER. These implicit joins are used in other party business components to map their main data. For example, if you added a field to the Account business component and then selected the Join property, you would see several joins that do not appear in the Join list displayed in the Tools Object List Editor, including joins with an alias of S_ORG_EXT and S_USER. These are implicit joins. The Join aliases are displayed as options in the Join property pick list on the Field object.
You can update the columns from this type of join.

Bookshelf Home | Contents | Index | Search | PDF