You are tasked with creating a report that combines data from a "sales" table and a "products" table. The requirement is to list all products, even those that haven't made a sale. Which JOIN operation would you choose?

  • LEFT JOIN
  • INNER JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
A LEFT JOIN retrieves all rows from the left table (products) and the matching rows from the right table (sales). It includes products with no matching sales, meeting the requirement.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *