SQL Query according to the situation shown in the body

Viewed 21

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.

0 Answers
Related