3 ms·
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
by DangitBobby 2y ago
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 2y agoAn inner join? Then there wouldn't be any nulls.
- DangitBobby 2y agoIDK, 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.