查询事件名称事件类型和分类
select NAME,
AE_TYPE,
(select LABEL
from sys_dict t1
where type = 'ae_type'
and t1.value = a.AE_TYPE) as "事件类型",
AE_CLASS,
(select LABEL
from sys_dict d2
where type = 'ae_class'
and d2.value = a.ae_class) as "事件分类"
from ae_sys_aename a
AE_TYPE,
(select LABEL
from sys_dict t1
where type = 'ae_type'
and t1.value = a.AE_TYPE) as "事件类型",
AE_CLASS,
(select LABEL
from sys_dict d2
where type = 'ae_class'
and d2.value = a.ae_class) as "事件分类"
from ae_sys_aename a
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步