SELECT * FROM AMUSTERI WHERE MUSADI IN (
SELECT DISTINCT CariAdi  FROM Adres WHERE NOT EXISTS (SELECT * FROM AMUSTERI WHERE MUSNO=CariNo)
)


SELECT * FROM AMUSTERI WHERE MUSADI IN (
SELECT DISTINCT CariAdi  FROM Adres WHERE NOT EXISTS (SELECT * FROM AMUSTERI WHERE MUSKOD =CariKodu)
)