Object Types Reference > Siebel Object Types >

Join

Siebel Object Types > Business Component > Join

Defines the logical join between a business component's base table and another table.

Properties

Property
Description/Usage
Valid Values/Examples
Name (R)
The name of the join object definition. This will automatically default to the table specified in the Table property. If there are two joins to the same table, then you need to change the name of one of them.
 
Outer Join Flag (O)
A TRUE or FALSE value.
TRUE = Indicates a left outer join.
FALSE = Indicates an inner join.
Table (R)
The name of SQL table. The name is case sensitive and must be specified the same as it is in the database.
 

See Also

Business Component
Join Specification

Usage

Siebel Object Types > Business Component > Join

SQL restrictions

Refer to SQL language reference manual for a complete explanation of and a list of restrictions on left, self, and simple joins.

Left outer joins

In defining a left outer join, the outer join is applied to the table defined by the join's Table property.

Fields on joined tables

Implicitly joined fields (unlike their explicit counterparts) can be updated.


 Object Types Reference 
 Published: 18 April 2003