So, let's say I had a table (call that "bar") that had one column in it, and like 5 rows, each with a different string value, like 'abc', 'def', ... etc.
I could LEFT JOIN against "bar" from another table (call that "foo"), which only happens to have a subset of those string values as rows in...