按照胡老板的教的做法做了,我添加了一个字段FGC_Creator,想法是根据这个字段可以通过查询命令知道登录人员的已发事项,问题是FGC_AssignTo有"全名"可以显示,FGC_Creator没有"全名",谁知道为什么?
with cte as (
Select FGC_Creator,FGC_AssignTo,FGC_State,"请假表" as tablename,id||"请假表" as key,id as "原表ID" from 请假
union all
select FGC_Creator,FGC_AssignTo,FGC_State,"报销表" as tablename,id||"报销表" as key,id as "原表ID" from 报销
)
select
(select count(*) from cte b where a.key >= b.key) as ID,
tablename as 目标表,
FGC_Creator,
FGC_AssignTo,
FGC_State as 状态,
原表ID
from cte as a
order by key
|