Element Details: Sql+Join

Available in: Logi Info Source code name: SqlJoin

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

Add a child SqlQuery to define the table or query to be joined.


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
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.
Set the JoinType to the type of Join desired. JoinType "InnerJoin" returns only those rows that have a match. The final number of rows is equal to or less than the original number of left-side rows. "LeftOuterJoin" returns all rows on the left side. Column values from the right side are added to the left side when there is a match. When there are multiple matching rows from the right side, those rows are also added to the output. "FullOuterJoin" returns all rows from both sides, combining those rows that match. "Union" concatenates all rows from both datasets together.


Click element to drill down for more information.

Sql Query


Click element to drill down for more information.

Match Condition Sql Query

 Back to top