活字格能否对外联表的建立视图

lwsammi · lwsammi

1818himis 发表于 2019-8-29 16:19
可以的，存储更灵活，效率不高，特殊情况用用。但是页面得直接能处理返回数据集先。

能请教一下我是5张表的数据怎么用存储过程合并成一张表字段都已经一一对应了
①SELECT b.ID, b.正式上岗日期, b.离职日期,  b.岗位 AS gangwei,  b.职场 AS zhichang,
  b.技能组 AS jinengzu ,'在岗'
FROM    dbo.员工信息表 AS b
where b.ID not in (select 员工信息表ID  from dbo.员工岗位变动表)

union all
⑤select a.员工信息表ID,a.原开始任职日期,a.调动时间,a.原岗位,a.原职场,a.原技能组,'在岗'
FROM dbo.员工岗位变动表 AS a
union all
②SELECT b.ID,  a.调动时间, b.离职日期, a.新岗位 AS gangwei, a.新职场 AS zhichang, a.新技能组 AS jinengzu,'在岗'
FROM    dbo.员工信息表 AS b LEFT OUTER JOIN
            dbo.员工岗位变动表 AS a ON  b.ID = a.员工信息表ID
where  b.岗位=a.新岗位 and b.职场=a.新职场 and b.技能组=a.新技能组
and a.调动时间 is not null
union all
④j2umn#aF5SELECT b.ID,b.入职日期 , b.正式上岗日期,  b.岗位 AS gangwei,  b.职场 AS zhichang,
  b.技能组 AS jinengzu ,'在培'
FROM    dbo.员工信息表 AS b
where b.ID not in (select 员工信息表ID  from dbo.员工岗位变动表)
union all
③SELECT b.ID,b.入职日期 , b.正式上岗日期,  a.原岗位 AS gangwei,  a.原职场 AS zhichang,
  a.原技能组 AS jinengzu ,'在培'
FROM    dbo.员工信息表 AS b LEFT OUTER JOIN
      (select aa.员工信息表ID,aa.dd,bb.原岗位,bb.原职场,bb.原技能组 from (select  a.员工信息表ID,min(a.原开始任职日期) dd from dbo.员工岗位变动表 AS a group by a.员工信息表ID )aa left join dbo.员工岗位变动表 AS bb on aa.员工信息表ID=bb.员工信息表ID
where aa.dd=bb.原开始任职日期)
AS a ON  b.ID = a.员工信息表ID

where b.ID  in (select 员工信息表ID  from dbo.员工岗位变动表)