We've seen that with an INNER JOIN, items that don't match the condition, like 0267, Lin Wong, aren't selected.

Make sure to type INNER JOIN.