select A.machine_no,A.version||'-'|| A.machine_id, case when B.version is not null then '开机中' else '停机' end from MES.SB_MACHINE_LIST A left join ( select distinct version,machine_id from mes.sb_measure_input where shift_date=to_date('${日期}','yyyy-mm-dd') and shift='${班次}' and model_name='${机种}') B ON B.version=A.version and B.machine_id=A.machine_id where A.Model_Name='${机种}'
--to_date('${日期}','yyyy-mm-dd') 或者 to_char('${日期}','yyyy-mm-dd')