Element Details: Sql+Query
 Back


Available in: Logi Info Source code name: SqlQuery

The ActiveSQL SqlJoin element joins two tables or queries together. ActiveSQL automatically generates the appropriate SQL join syntax.

Add a SqlQuery under a SqlJoin element to define the table or query to be joined.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ID
UserDefined
The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
Source
UserDefined
(Required) A SQL statement that returns a set of records. Use tokens, such as @Request and @Session, inside of the SQL command to control the result set.



PARENT ELEMENTS

Click element to drill down for more information.

Sql Join


CHILD ELEMENTS

Click element to drill down for more information.

Sql Aggregate Column
Sql Calculated Column
Sql Condition Filter
Sql Group
Sql Join
Sql Sort
Sql Time Period Column


 Back to top


 Chart Debug