select imsi from NX_SUBSCRIBERS where hlr_id= 0 and MISC_SERV_SEND_A_NOTIF_CD=0 select 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语句得到下面的结果么? 我最终想要的结果是 ims