SELECT KEY_ID_TAG,accuml_map_to_fes.DESCRIPTION,accuml_map_to_fes.RTU_TAG,accuml_map_to_fes.DOT_NO, fes_accuml.TAG_NAME, fes_accuml.DESCRIPTION,fes_dev_info.TAG_NAME,fes_dev_info.DEV_DESC
FROM accuml_map_to_fes LEFT JOIN (fes_accuml INNER JOIN fes_dev_info ON fes_accuml.DEV_TAG = fes_dev_info.TAG_NAME)
ON fes_accuml.TAG_NAME = concat(accuml_map_to_fes.RTU_TAG,'.',accuml_map_to_fes.DOT_NO) WHERE KEY_ID_TAG LIKE 'accuml.QHB.DTS432-311Xinst242.%';
SELECT tblA.KEY_ID_TAG,tblA.DESCRIPTION,tblA.OFFSET_NO,fes_analog_ctrl.DESCRIPTION,tblA.RTU_TAG,tblA.DOT_NO,fes_analog.DESCRIPTION,fes_dev_info.TAG_NAME,fes_dev_info.DEV_DESC
FROM
((SELECT analog_map_to_fes.KEY_ID_TAG,analog_map_to_fes.DESCRIPTION,analog_control.OFFSET_NO,analog_map_to_fes.RTU_TAG,analog_map_to_fes.DOT_NO
FROM analog_map_to_fes LEFT JOIN analog_control ON analog_map_to_fes.KEY_ID_TAG = concat('analog.',analog_control.TAG_NAME)
WHERE analog_map_to_fes.KEY_ID_TAG LIKE 'analog.QHB.300JGXX620Xinst248.%') AS tblA
LEFT JOIN fes_analog
ON fes_analog.TAG_NAME = concat(tblA.RTU_TAG,'.',tblA.DOT_NO))
LEFT JOIN fes_analog_ctrl
ON fes_analog_ctrl.TAG_NAME = concat(tblA.RTU_TAG,'.',tblA.OFFSET_NO)
LEFT JOIN fes_dev_info
ON fes_analog.DEV_TAG = fes_dev_info.TAG_NAME