1.临时表
此处需要存储一次select的结果集用来进行第二次连接。
with temp1 as (select * from t_energy_type where company_id = 991897881281560576 and del_status = 1),
temp2 as (select b.value, a.energy_type_id
from t_energy_type a
left join t_unit_consumption b on b.energy_type_id = a.energy_type_id and b.del_status = 1
left join t_system_group c on c.group_id = b.group_id and c.del_status = 1
where a.del_status = 1
and a.company_id = 991897881281560576
and b.type = 'M' -