1-) MSSQL Athena -  BİR TABLODA OLUP DIGERINDE OLMAYAN

SELECT * FROM PERDEPLAN

WHERE

NOT EXISTS(SELECT PERDEP_RECNO FROM PERDEP WHERE PERDEP_RECNO=PERDEPLAN.PERDEPLAN_JOIN_REFNO)