What are the main types of joins?medium
Answer
INNER, LEFT, RIGHT, FULL OUTER, and CROSS JOIN are common join types.
Explanation
Inner joins return matches, outer joins preserve unmatched rows, and cross joins return every row combination.
Follow-upHow do you find records missing from another table?