TSQLJoin Class
Represents a SQL JOIN between two relations, carrying the join type, key-pair conditions, and any custom SQL conditions.
Syntax
Unit: Aurelius.Sql.BaseTypes
TSQLJoin = class(TSQLRelation);Constructors
| Name | Description |
|---|---|
| Create | Overloaded Create Create(TSQLRelation, TSQLRelation, TJoinType) |
Properties
| Name | Description |
|---|---|
| CustomSegments | Gets the list of raw SQL conditions appended to the ON clause of this join. |
| JoinType | Gets or sets the type of SQL JOIN (INNER or LEFT OUTER) to generate. |
| LeftRelation | Gets or sets the left-hand relation in the join (e.g., a TSQLTable or nested TSQLJoin). |
| RightRelation | Gets or sets the right-hand relation in the join (e.g., a TSQLTable or nested TSQLJoin). |
| Segments | Gets the list of key-pair conditions that form the ON clause of this join. |