function (table1
as table, optionalkey1
as nullable any, optionaltable2
as nullable any, optionalkey2
as nullable any,newColumnName
as text, optionaljoinKind
as nullable any, optionalkeyEqualityComparers
as nullable list) as table
table1
with the rows of table2
based on the equality of the values of the key columns selected by key1
(for table1
) and key2
(for table2
). The results are entered into the column named newColumnName
.joinKind
specifies the kind of join to perform. By default, a left outer join is performed if a joinKind
is not specified.keyEqualityComparers
may be included to specify how to compare the key columns.