join¶
Join the active dataset with a named table.
When to use
How do I bring lookup fields into the current dataset?
Rows are grouped by active-row order. For each active row, matching rows from the named table stay
in their stored order, including duplicate matches.
An inner join omits unmatched active rows; a left join keeps one row with missing right-side values for
each unmatched active row.