I have two tables named Cities and Banks
Cities have Columns named CityId and CityName
Banks have a Column BankCity.
BankCity have data same as in CityName, but i want to replace BankCity data with CityId.
But I cant find a query for it.
I have two tables named Cities and Banks
Cities have Columns named CityId and CityName
Banks have a Column BankCity.
BankCity have data same as in CityName, but i want to replace BankCity data with CityId.
But I cant find a query for it.