select b.switch_name,a.reserved_field1,count(*) num from c_redo_eventbill_link a,b_switch_infobill_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_F