CIBC Interview Question

Explain difference between SQL Joins