Skip to content

Latest commit

 

History

History
17 lines (12 loc) · 1.13 KB

Database-QueryJoinOn-Config-Xml.md

File metadata and controls

17 lines (12 loc) · 1.13 KB

'QueryJoinOn' object (database-driven)

The QueryJoinOn object defines the join on characteristics for a join within a query.


Properties

The QueryJoinOn object supports a number of properties that control the generated code output. The following 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). [Mandatory]
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.