Are you sure your simplified example accurately reflects the original? There must be some reason he's preferring the left join, though it's not obvious from the example.