[DangitBobby]

And yet when you do a join because you need to actually use that data, the resulting table will have a column with nulls in it. Any way you squeeze it, you need a way to represent empty values for your database to be useful.

[mnsc]

An inner join? Then there wouldn't be any nulls.

[DangitBobby]

IDK, do you want to exclude people without a middle name or a second address line when examining a product order list? I'll leave that one for you to decide.