"not exists" SQL

[dpora1979]

Gurus,

I'm not getting the correct results from my query and I wanted to see if I could get some help.

I want to get data from the bld table that doesn't exist in the kom table. Simple right? What am I doing wrong???

select distinct bldbezc, bldkeyi from bld where not exists (
select distinct b.bldbezc, b.bldkeyi, k.kombezc, k.komkeyi from bld b, kom k
where k.komtyps = 3
and k.komlf1i = b.bldkeyi );

Zero results!

I know for a fact there about 6,000 records!!!!

Any help would be great ... Thank you

[ebrian]

Two options could be:

SELECT a1,
       a2
FROM   table1 t1
WHERE  NOT EXISTS (SELECT NULL
                   FROM   table2 t2
                   WHERE  t1.a1 = t2.a1
                   AND t1.a2 = t2.a2);


SELECT *
FROM   table1
WHERE  (a1, a2) NOT IN (SELECT a1,
                               a2
                   	FROM   table2
	                WHERE  a1 IS NOT NULL 
                    	AND a2 IS NOT NULL );

[LKBrwn_DBA]

Why not try this:

SELECT DISTINCT bldbezc, bldkeyi
           FROM bld
MINUS
SELECT DISTINCT k.kombezc, k.komkeyi
           FROM kom k
          WHERE k.komtyps = 3;