I have two table table1 and table2. I want to select from table1 where id not in table2 id.

```
table1
id     name
001    Testing
002    Hello
003    World
004    Programmer

table2
id     name
001    Testing
003    World

```

my expectation

```
id     name
002    Hello
004    Programmer

```

i try these code

```
SELECT * FROM table1 as a where a.id <> (SELECT b.id from table2 as b )

```

Any solution for these?