With LEFT JOIN, left-table items without a match, like 0267, Lin Wong, appear connected to empty table cells.

Make sure to pick LEFT, followed by JOIN.