select ss.system_id,ss.system_name,i.* from subsystem ss , ACQUIREDS a, meters m ,TMRLOG.DAYDATA_TRANSFER_RECORD i where ss.system_code=a.region_code and a.acquired_id=m.acquired_id and m.meter_id=i.obj_id and i.data_type = 6 and ss.system_id= 17 and i.occur_date>='2018-06-01 00:00:00.0' and i.occur_date<='2018-06-01 00:00:00.0' and i.interface_id =14000000001