SQL查询以显示在不同移动网络中注册的移动号码

I am suffering from a situation where a user has changed his mobile network and subscribed our service but their mobile number is same. So, for his old subscription I have his old mobile network and for his new subscription, I have his new mobile network record. I am suffering from a situation where a user ha