There must be some reason he's preferring the left join, though it's not obvious from the example. As far as equivalence, they're not going to have the same effect.

So in this instance there is data to CRD1.StreetNo, so only card code, street, and block display data, bit city, state, or zip. If I comment out StreetNo, my city, state, and zip appear.