CPA · Question 29 · Area I: Information Systems
A developer is writing a SQL query to combine customer data from the 'Sales' table and the 'Support' table. They want to see ALL customers from the 'Sales' table, and matching support tickets if they exist. If a customer has no support tickets, they should still appear in the list. Which JOIN type should be used?
Answer options:
INNER JOIN
RIGHT JOIN
LEFT JOIN
CROSS JOIN
82 questions · hints · full answers · grading
Expert