Today at work, a report of mine was writing code equivalent to the following query: select items.id from items join subitems on items.id = ...