found the solutions...

actually if the tables lie in different dbs

then create temp table in db X that contain the data of tableB from db Y

this way our both tables now in same db as X

now simply we can update from one table to another as usual 🙂