select imsi from NX_SUBSCRIBERS where hlr_id= 0 and MISC_SERV_SEND_A_NOTIF_CD=0select msisdn from nx_bs_code where imsi in ( select imsi from NX_SUBSCRIBERS where hlr_id= 0 and MISC_SERV_SEND_A_NOTIF_CD=0)
这是两条sql语句,,能用一条sql语句得到下面的结果么?
我最终想要的结果是
imsi msisdn
222 33333
222 33333Oracle
这是两条sql语句,,能用一条sql语句得到下面的结果么?
我最终想要的结果是
imsi msisdn
222 33333
222 33333Oracle
select msisdn,imsi from nx_bs_code where imsi in ( select imsi from NX_SUBSCRIBERS where hlr_id= 0 and MISC_SERV_SEND_A_NOTIF_CD=0)
第2个sql得到的是什么结果?
select t1.imsi, t2.msisdn
from NX_SUBSCRIBERS t1
left join nx_bs_code t2
on t1.imsi = t2.imsi
where hlr_id = 0
and MISC_SERV_SEND_A_NOTIF_CD = 0
select imsi, msisdnfrom nx_bs_code where imsi in (select imsi from NX_SUBSCRIBERS where hlr_id= 0 and MISC_SERV_SEND_A_NOTIF_CD=0)