Bookshelf Home | Contents | Index | PDF     

Siebel Object Types Reference > Siebel Object Types Reference > Business Component Object Types >

Join

A join defines the logical join between the table that a business component references and another table. Siebel CRM can update an implicit joined field. It cannot update an explicit join. For a complete explanation of restrictions on left, self, and simple joins, see an SQL language reference manual.

This object type occurs in the following location in the object hierarchy:

Table 67 describes properties that Siebel CRM uses with a join.

Table 67. Properties of the Join
Property
Description

Name (R)

Specifies the name of the join object definition. This value defaults to the table that the Table property specifies. If two joins to the same table exist, then you must modify the name of one of these joins.

Outer Join Flag (O)

You can use one of the following values:

  • TRUE. Indicates a left outer join. Siebel CRM applies an outer join to the table that the Table property of the join defines. It receives values even if the join returns no values.
  • FALSE. Indicates an inner join.

Table (R)

Specifies the name of an SQL table. This name is case sensitive. It must use the same format that the table name uses in the Siebel database.
    
Siebel Object Types Reference Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.