sql - i have two table find out only mismatch id -

sql - i have two table find out only mismatch id -

table 1:

id 1 2 3 5 6

table 2:

id 2 3 7

i want mismatch id table 1 result should 1,5,6.

please help on this, in advance.

try this:

select * table1 id not in (select id table2)

sql