MySQL LEFT JOIN INNER JOIN实例

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