You can use join instead.
For example, you have City in a logical table, and a separate table that has City and Country, and you want to get Country into the first table. One way is to use the second table as map, and apply this map in the first table. Or, if you don't want mapping, you can join the second table to the first.
But - what's wrong with mapping?