Write an SQL statement to list for all properties for rent the propertyNo, the city the property is located, the city of the branch which is contracted to rent the property, as well as the city of the branch that provides the individual staff who handles the actual renting of the property.Insert enough records, if necessary, to show that these 3 cities for a given property could be totally different
I am able to join the branch and Property for rent but i am stuck while retrieving the city for the branch that provides the staff. As mentioned by the question I need three different cities but I only get the same 3 cities.
My Solution: [sql script][2] Sorry couldnt copy
