gistfile1.txt

-- The results of Joins are equivalent to everything that evaluates to true in these comparisons:

-- INNER JOIN:
-- "A && B" == "A and also B"

-- FULL JOIN:
-- "A || B" == "A or B or both"

-- LEFT JOIN:
-- "A || (A && B)" == "A with or without B"

-- LEFT OUTER JOIN:
-- "A && !(A && B)" == "A but not B or both"

-- RIGHT JOIN:
-- "B || (A && B)" == "B with or without B"

-- RIGHT OUTER JOIN:
-- "B && !(A && B)" == "B but not A or both"

-- FULL OUTER JOIN:
-- "A ^ B" == "A or B but not both"