JOIN.INNER, JOIN.LEFT, JOIN.RIGHT and JOIN.FULL

Join two neutral tables to a joined table result. The three join commands can join at a specified column from each table. The result will be all the columns from the left site and new columns from the right site (columns defined in both tables will be taken from the left site). JOIN.RIGHT is introduced in 2023-R2.

Properties

From	Name of the left Input Data Source.The source must contain the neutral Table-format.
To	Name of the right Input Data Source and the result. The input will be overwritten be the result. The source must also be the neutral Table-format.

Parameters

@LeftKeyColumn	Specifies the column name of the key in the left table. The parameter is optional and if not specified, the first column well be used as the key.
@RightKeyColumn	Specifies the column name of the key in the right table. The parameter is optional and if not specified, the first column well be used as the key.

Map

This Command does not use any value mappings.

Guide

Simple joins from to tables. Remarks: the column "Text" exists I both tables and only data from the Left Table will be taken from the "Text" column. The _Value has duplicates for respectively 4 and 2 in the two tables and this will generate two rows in the results. To avoid this, use the SELECT.UNIQUE command to remove duplicates rows.

Left Table		Right Table
_Value	Text	_Value	Text	Color
1	Txt1	1	Txta	Blue
2	Txt2	2	Txtb	Gray
3	Txt3	2	Txtc	Green
4	Txt4	4	Txtd	Red
4	Txt5	5	Txte	Yellow

Inner join result			Left join result			Full join result
_Value	Text	Color	_Value	Text	Color	_Value	Text	Color
1	Txt1	Blue	3	Txt3		3	Txt3
2	Txt2	Gray	1	Txt1	Blue	1	Txt1	Blue
2	Txt2	Green	2	Txt2	Gray	2	Txt2	Gray
4	Txt4	Red	2	Txt2	Green	2	Txt2	Green
4	Txt5	Red	4	Txt4	Red	4	Txt4	Red
			4	Txt5	Red	4	Txt5	Red
						5		Yellow

1 Properties
2 Parameters
3 Map
4 Guide