Riho-Rene,
what about something like

SELECT KORTER, SUM(ULDPIND) FROM KORTERID K
WHERE MAJA='Kurni 34' AND
NOT EXISTS (SELECT * FROM EIMAKSA E WHERE K.ID = E.KORTER AND E.KULU=5)
GROUP BY KORTER

HTH,
Set

Riho-Rene Ellermaa wrote:
I want to SUM(ULDPIND) for all KORTER's which are not in table EIMAKSA where
MAJA='Kurni 34' and KULU=5.