MySQL – List Records That Don’t Exist From Another Table

SELECT * FROM product t1
LEFT JOIN promo_product t2 ON t1.idProduct = t2.product_idProduct
WHERE t2.idPromoProduct IS NULL