Make it clear that the LEFT JOIN functionality is actually generic in join type