Merge Queries joins two tables on one or more matching columns, like an SQL join. The join type (inner, left outer, etc.) determines which rows are kept; the result is added as a nested column to expand.
Example
Table.NestedJoin(Ventes, "IdProduit", Produits, "Id", "Produit", JoinKind.LeftOuter)