JOIN with correlated subquery
JOIN with NOT EXISTS operator
JOIN with EXISTS operator
JOIN with subselect
JOIN with CTE (Common Table Expression)