How to select from two MySQL tables?

Question

MySQL

I have two tables
product (id, name, price, description)
wishlist (product_id, user_id)
I need to select all records from the product table and add the key `inlist` 1 or 0, depending on whether there is a record with wishlist.product_id =product.id

Answer 1

SELECT
    p.*,
    NOT ISNULL(wl.product_id)
FROM product as p
LEFT JOIN wishlist as wl ON p.id = wl.product_id;

UPDATE thanks @AxisPod