Let's say I have 2 tables, recently added new column in tbl\_review called city and wishing for it to be filled from other table (tbl\_bus)

```
tbl_review (uid,bid,rate,city)

tbl_bus (bid,city,lat,long)

```

normally I would join

```
select A.city B.uid from tbl_bus A inner join tbl_review B on A.bid=B.bid

```

Now i want to insert city value based on data in tbl\_bus, is it possible?

Thanks