How to get the difference between two similar tables (complement)

[johny10151981]

Dear All,
I am having a bit problem with a simple development.
I am not into Queries but I need this.
Lets follow the example below

tble1
---------------------------------
| ID | Name
---------------------------------
| 1 | johny
---------------------------------
| 2 | rony
---------------------------------
| 3 | Anne
---------------------------------

tbl2
---------------------------------
| ID | Name
---------------------------------
| 1 | johny
---------------------------------
| 3 | Anne
---------------------------------

I need the query of complement: The returned result would be
---------------------------------
| ID | Name
---------------------------------
| 2 | rony
---------------------------------

Please I need the solution
Best Regards,
Johny

[acoolguy]

We need more information like whats the fields called and what your trying to do exactly?

[johny10151981]

The query would be,

SELECT M.ID
FROM tble1 AS M
WHERE M.ID NOT
IN (
SELECT P.ID
FROM tbl2 AS P
)

Regards,
Johny