[SQL] SQL Query: How to return products that don't have reviews

I have a table of reviews and a table of products. E.g. the following dummy data:





I want to return only the products that do not have any reviews.

My SQL code is currently

SELECT *
FROM products
LEFT JOIN reviews
ON products.id = reviews.product_id
WHERE reviews.content IS NULL;


As each product has multiple reviews, only some of which are null, I'm concerned that this approach returns false negatives (i.e. I don't want products that are associated with some empty reviews among other completed reviews, I only want products for which no reviews exist at all). Do I need to add a HAVING clause?

Thanks much for your help in advance.

Continue reading...