Can someone explain how nested joins work? I've never seen this before.

Thanks