Kod: Tümünü seç
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'
Teşekkür Ederim...