Thank you for your answers.

EXCEPT and NOT EXISTS works good for me.

I m new to sql so the commands and operators that i know is noting compared to you all....

data types in the table ID is INT and CODE is varchar.

I converted ID to a varchar and add it to CODE to obtain a unique column.

it works fine...