select o.bolge_no, o.abone_no, o.sira_no, o.abone_id ,i.id
from odeme_giris o
join internet i on o.bolge_no = i.bolge_no and o.abone_no = i.abone_no and o.sira_no = i.sira_no
where (o.bolge_no, o.abone_no, o.sira_no) in (select bolge_no, abone_no, sira_no
from internet)
and o.bolge_no = '103051' and o.abone_no = '5532I'

update (select o.bolge_no, o.abone_no, o.sira_no, o.abone_id ,i.id
from odeme_giris o
join internet i on o.bolge_no = i.bolge_no and o.abone_no = i.abone_no and o.sira_no = i.sira_no
where (o.bolge_no, o.abone_no, o.sira_no)
in (select bolge_no, abone_no, sira_no from internet)
and o.bolge_no = '103051' and o.abone_no = '5532I') x
set x.abone_id = x.id