Hi!

I have a query with no results and I doo't understand what I do wrong:

SELECT DENSUB, CODSUB from SUBANS,TEMPSUB

WHERE SUBANS.CODSUB=TEMPSUB.CODSBB AND SUBANS.CODSUB NOT IN (SELECT CODSBB FROM TEMPSUB) AND SUBANS.CODPF='FL1' order by SUBANS.DENSUB asc

The query must return some values but, I don't get any errors nor results.

Can you help me, please.

Thanks

L