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