For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Outer full and inner SQL joins: you are wellcome
Gioorgi
Make the impossible possible, make the possible easy, and make the easy elegant (Moshé Feldenkrais)