T-SQL 101: #107 Using other outer joins with RIGHT OUTER JOIN, FULL OUTER JOIN - The Bit Bucket

https://blog.greglow.com/2025/02/03/t-sql-101-107-using-other-outer-joins-with-right-outer-join-full-outer-join/