Apply map is used to add fields to tables with the help of other tables. Thanks mate, I tried the outer apply query, it returns the same value in bar table for all IDs in foo. EMP Table: 37-403B If I replace '=' with '>/>=' or '