An analogue of array_diff with a mysql query, how is it correct?

Question

PHP

There are 2 tables, in one and in the second there are fields example_id.
One has 1000 entries, the other has 1200 entries. In fact, I need to make a conclusion using mysql similar to the function array_diff(table1.example_id, table2.example_id); Simply put, you can find the values ​​that are missing in the second table.
But it is not possible to make a request.

Answer 1

LEFT JOIN, WHERE ... IS NULL