SQL Question (selecting records from a table with a codthat do not appear on another)

Hello,

I need to select the records from a table that DO NOT have a record in another table.

For Example

Table1
Code | Name
0 | AA
1 | A0
2 | A00

Table2
Code1 | Code2
1 | 100
2 | 200

So the SQL would return only the record "0 | AA" from the table "Table1".

Any ideas?

Thanks.

Solved.

Used two queries with IN.

Thanks.

In one query:

SELECT stuff FROM tableA
LEFT JOIN tableB ON tableA.col = tableB.col
WHERE tableB.col IS NULL

🙂