https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
INNER JOIN
SELECT <select_list>
FROM Table_A A
INNER JOIN Table_B B
ON A.Key = B.Key
LEFT JOIN
https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
INNER JOIN
SELECT <select_list>
FROM Table_A A
INNER JOIN Table_B B
ON A.Key = B.Key
LEFT JOIN