SQL Joins explained for normal people:
INNER JOIN: Mutual match on Tinder.
LEFT JOIN: You liked them, they ignored you.
RIGHT JOIN: Psychopath behavior, just use a Left Join.
FULL OUTER JOIN: Hoarding everyone just in case.
CROSS JOIN: Swiping right on every single person.