-- update all invalid departments in gl:
UPDATE gl SET department_id = NULL WHERE department_id NOT IN (SELECT id FROM department);
-- update all invalid departments in gl:
UPDATE gl SET department_id = NULL WHERE department_id NOT IN (SELECT id FROM department);