select b.switch_name,a.reserved_field1,count(*) num from c_redo_event@bill_link a,b_switch_info@bill_link b where a.switch_id=898529 and error_id=2000 and a.reserved_field1=b.switch_id group by a.reserved_field1,b.switch_name /* SWITCH_NAME RESERVED_FIELD1 NUM C网集团彩铃功能月租 898520 7910 C网集团下发ISMP