Use this
SELECT a.Id,a.desr,from_Location.Location,to_Location.Location,from_Division.Division,to_Division.Division
FROM accounts a inner join location from_Location On a.from_Location_Id=from_Location.locationId
inner join location to_Location On a.To_Location_Id=to_Location.locationId
inner join Division from_Division On a.from_Division_Id=from_Division.DivisionId
inner join Division to_Division On a.To_Division_Id=to_Division.DivisionId
Hope this helps , If yes then accept it and vote it otherwise revert back with your queries.
--Rahul D.