Nofuserex -

-- Option 1: Update orphaned records to a default system user UPDATE transactions SET created_by_user_id = 1 -- system account ID WHERE created_by_user_id NOT IN (SELECT id FROM users);