Untitled

DELETE from CU_NOTIFICATION_MICRO_CATEGORY
WHERE NOTIFICATION_MICRO_CATEGORY_ID IN (
	SELECT NOTIFICATION_MICRO_CATEGORY.ID
	FROM NOTIFICATION_MACRO_CATEGORY 
	INNER JOIN NOTIFICATION_MICRO_CATEGORY
		ON NOTIFICATION_MICRO_CATEGORY.NOTIFICATION_MACRO_CATEGORY_ID = NOTIFICATION_MACRO_CATEGORY.id
	WHERE MACRO_CATEGORY_NAME = 'SHEET_COLLATION'
);

DELETE FROM NOTIFICATION_MICRO_CATEGORY
WHERE NOTIFICATION_MICRO_CATEGORY.NOTIFICATION_MACRO_CATEGORY_ID =
	(SELECT id FROM NOTIFICATION_MACRO_CATEGORY WHERE MACRO_CATEGORY_NAME = 'SHEET_COLLATION')
;

DELETE FROM NOTIFICATION_MACRO_CATEGORY WHERE MACRO_CATEGORY_NAME = 'SHEET_COLLATION';