Agreed. Indeed the example is quite misleading as it pointedly does not illustrate the most common case, which os of a small lookup table appearing in multiple

Agreed. Indeed the example is quite misleading as it pointedly does not illustrate the most common case, which os of a small lookup table appearing in multiple result rows.