DELETE FROM THESIS
WHERE KEY_ENROLMENT IS NULL
   OR KEY_ENROLMENT NOT IN (SELECT ID_INTERNAL FROM CURRICULUM_MODULE 
				   		 	WHERE OJB_CONCRETE_CLASS LIKE '%Enrolment%');
