JOIN is short for INNER JOIN because it only selects those rows with a common value in a specific column like id.