Untitled

-- 1
SELECT u.id, u.name, u.code, u.workUnitCode 
FROM bsi.mrms.usermanagement_regions u 
WHERE u.code IN ('ID00119002', 'ID1239');

-- 2
SELECT ua.id, ua.name, ua.code, ua.workUnitCode, ua.regionId
FROM bsi.mrms.usermanagement_areas ua 
WHERE ua.code IN ('ID0010011a', 'ID0018053a','ID0019052a','ID1231');