The QueryJoinOn
object defines the join on characteristics for a join within a query.
The QueryJoinOn
object supports a number of properties that control the generated code output. The properties with a bold name are those that are more typically used (considered more important).
Property | Description |
---|---|
Name |
The name of the join column (from the Join table). |
ToSchema |
The name of the other join to table schema. Defaults to Table.Schema ; i.e. same schema. See also ToTable and ToColumn as these all relate. |
ToTable |
The name of the other join to table. Defaults to Table.Name ; i.e. primary table. See also ToSchema and ToColumn as these all relate. |
ToColumn |
The name of the other join to column. Defaults to Name ; i.e. assumes same name. See also ToSchema and ToTable as these all relate. |
ToStatement |
The fully qualified name (Alias.Name ) of the other column being joined to or other valid SQL (e.g. function) bypassing the corresponding Schema , Table and Column logic. |
Note: This markdown file is generated; any changes will be lost.