Delete record by comparing values between two tables

Question

I have two tables:

produtos
- id_produto

valores
- id_produto

id_produto would be a column, equal for the two tables.

I need to delete the records from the table values, but only those that are NOT also in the table products.

Ex:

I have two products registered, and in the table values owned the ID of these two products. For some reason I deleted a product from the table products, but the record was there in the table values.

I want to erase that record there.

How can I do that?

Answer 1

Make a DELETE with a SUB-SELECT:

DELETE FROM valores WHERE id_produto NOT IN (SELECT id_produto FROM produtos);