规划院培训费用统计查询的sql语句

最新推荐文章于 2025-08-20 22:49:45 发布

原创最新推荐文章于 2025-08-20 22:49:45 发布 · 515 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

本文介绍了一个用于整合不同来源培训数据的SQL视图创建方法。该视图从多个表中抽取数据，包括人员信息和个人培训记录等，实现了统一的数据展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

create or replace view pxfy_view as
select t1.form_id,t1.reserve as mid,t1.feiyong,t.cjpxr_name as full_name,1 as pxlx,t1.topic,t1.identity,
t1.begin_time as CREATEDATE,t1.end_time as completedate,pv.city,pv.DEPT_ID
from wf_oa_pxnb_cjry t,WF_OA_PXNB t1,person_view pv where t.form_id=t1.form_id and t.cjpxr=pv.ACCOUNT

     union all
    select t1.form_id,t1.reserve as mid,t1.feiyong,t.cjr_name as full_name,0 as pxlx,t1.topic,t1.identity,
    t1.begin_time as CREATEDATE,t1.end_time as completedate,pv.city,pv.DEPT_ID
     from wf_oa_px_pxjl t,WF_OA_PX t1,person_view pv where t.form_id=t1.form_id and t.cjr=pv.ACCOUNT