本帖最后由 Eric.Liang 于 2019-7-12 11:55 编辑
一看就会,超有用活字格技能:五十一,将所有有工作流的表,汇总成一张待办事项表 - 专题教程 - 葡萄城产品技术社区 https://gcdn.grapecity.com.cn/forum.php?mod=viewthread&tid=53583
- with cte as (
- Select FGC_AssignTo,FGC_State,"请假表" as tablename,id||"请假表" as key,id as "原表ID" from 请假
- union all
- select 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_AssignTo as 执行者,
- FGC_State as 状态,
- 原表ID
- from cte as a
- order by key
复制代码 按照上面的网址链接示例,在创建视图时,提示语法/结构出错,烦请指导,谢谢!
|