In R, type the inner join of lines and products on sku.
In R, type the inner join of lines and products on sku.
Answer
merge(lines, products, by = "sku")
The default all = FALSE keeps only keys present in both tables: 4 rows, D400 dropped, sorted by sku.