If you are using Repeater control then go to your repeater properties -> Edit Query and write simple SQL Query to join both tables (something like below)
SELECT emp.ItemID, emp.Name, loc.Name
FROM CustomTable_Employee emp
JOIN Employee_Location loc
ON emp.EmployeeLocationId = loc.ItemID
and then You can add returned columns in Selected columns properties of repeater.