0267, Lin Wong from students won't appear in the results. That's because there's no id value 0267 in the enrolled table.

Make sure to pick = followed by enrolled and then ., id.