Update x
Set x.kullaniciadi=y.kullaniciadi
From y
inner join x on y.ip=x.ip
Where y.ip=‘192.168.1.1’