not exist

[Forestq]

I have two tables. In each table I have the same ID.

example: table 1
column1: id_A
column2: name

example: table 2
column1: id_B
column2: second_name

how to check by SQL which ID from table 1 doesn't exist in the second table?

something like:

select id_A from table1 t1
left join table2 t2 on t1.id_A = t2.id_B
where not exist (select....

please help

 

[Kreszch68]

SELECT Table1.id_A
FROM Table1 LEFT JOIN Table2 ON Table1.id_A = Table2.id_B
WHERE Table2.id_B Is Null

 

[Forestq]

Thx !!!