SELECT EmployeeID, C1.CityName AS CurrentCity, C2.CityName AS PreviouCity FROM Employee E LEFT JOIN City C1 ON E.CurrentCityID = C1.CityID LEFT JOIN City C2 ON E.PreviousCityID= C2.CityID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)