Outer full and inner SQL joins: you are wellcome

For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins