mysql - Is there a way where i can find the missing numbers from 1 table to another table? (Comparison)

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65650106/is-there-a-way-where-i-can-find-the-missing-numbers-from-1-table-to-another-tabl

Answer 1

Try this:

SELECT 
    num
FROM
    first_table t1 
WHERE
    num 
NOT IN 
    (SELECT 
        num 
     FROM 
        second_table
    );