https://www.sqlservertutorial.net/sql-server-basics/sql-server-left-join/
Anonymous
Fold knowledge into data so program logic can be stupid and robust.