Yes, it keeps nulls from appearing on important fields. Left join included nulls from the right. Right join excluded omissions. Though admittedly one might fin

Yes, it keeps nulls from appearing on important fields. Left join included nulls from the right. Right join excluded omissions. Though admittedly one might find alternative conditions for similar behavior.