update user1 set email=b.email from user1 a join user2 b on a.username=b.usernameupdate user1 set mflag='weil' update user2 set mflag='weil'
update user1 set a.email=b.email from user1 a ,user2 b where a.username=b.username update user1 set mflag='wei1' update user2 set mflag='wei1'
update a set email=b.email from user1 a join user2 b on a.username=b.usernameupdate user1 set mflag='weil' update user2 set mflag='weil'
update t1 set t1.email=t2.email from user1 t1,user2 t2 where t1.username=t2.usernameupdate user1 set mflag=1 where mflag=0 update user2 set mflag=1 where mflag=0
update user2 set email=user1.email from user1 where username=user1.usernameupdate user1 set mflag=weil where mflag=0update user2 set mflag=weil where mflag=0
set email=b.email
from user1 a join user2 b on a.username=b.usernameupdate user1 set mflag='weil'
update user2 set mflag='weil'
update user1 set mflag='wei1'
update user2 set mflag='wei1'
set email=b.email
from user1 a join user2 b on a.username=b.usernameupdate user1 set mflag='weil'
update user2 set mflag='weil'
set t1.email=t2.email
from user1 t1,user2 t2
where t1.username=t2.usernameupdate user1
set mflag=1
where mflag=0
update user2
set mflag=1
where mflag=0
update user2
set email=user1.email
from user1
where username=user1.usernameupdate user1
set mflag=weil
where mflag=0update user2
set mflag=weil
where mflag=0