当我更新另一个表中列的数据时，如何修改一个表中列的数据？

I have two tables 'login' and 'editprofile' with the same column 'password'. Whenever a user edits his/her password which is under 'editprofile', it should also change the column 'password' of 'login' table. Is there a way to execute this, without joining both tables? Thanks.I have two tables 'login' and 'editprofile' wit