https://quadexcel.com/wp/advanced-or-intelligent-joins-in-sql-server-part-13/