CODE EXAMPLE FOR SQL

mysql left join exists

SELECT * FROM customer
LEFT JOIN product ON product.customerId = customer.id
WHERE product.customerId IS NOT NULL	# which means customer id should exists