* Lists ELENO in LISTRxxx but not in LISTRALL SELECT DISTINCT LISTR522.ELENO FROM LISTR522 WHERE LISTR522.ELENO NOT IN (SELECT DISTINCT LISTRALL.ELENO FROM LISTRALL) SELECT COUNT(*) FROM LISTRALL, LISTR522 WHERE LISTR522.ELENO=LISTRALL.ELENO AND LISTR522.CONVERT != LISTRALL.CONVERT SELECT * FROM LISTRALL, LISTR522 WHERE LISTR522.ELENO=LISTRALL.ELENO AND LISTR522.CONVERT != LISTRALL.CONVERT