Element Details: Sql+Join
 Back


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.



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.
JoinType
LeftOuterJoin
InnerJoin
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.



PARENT ELEMENTS

Click element to drill down for more information.

Sql Query


CHILD ELEMENTS

Click element to drill down for more information.

Match Condition Sql Query


 Back to top