I have 2 tables

- SUBANS with fields CODSUB and DENSUB

- TEMPSUB with fields CODSBB and CANT

- Records in CODSUB and CODSBB are the same

I want to retrieve all the SUBANS records for which SUBANS.CODSUB is not EQUAL with TEMPSUB CODSBB.

Because of that matter, I manufacture that query :)