本帖最后由 左一 于 2022-11-21 13:38 编辑
在活字格里写的视图，放到mysql里去写就不行了。求教怎么改？- with cte as(
- Select "合同档案" as 目标表,合同编号,甲方主体 as 主体 from "合同档案"
- union all
- Select "合同档案" as 目标表,合同编号,乙方主体 as 主体 from "合同档案"
- union all
- Select "合同档案" as 目标表,合同编号,丙方主体 as 主体 from "合同档案"
- union all
- Select "合同档案" as 目标表,合同编号,丁方主体 as 主体 from "合同档案"
- union all
- Select "合同档案" as 目标表,合同编号,戊方主体 as 主体 from "合同档案"
- union all
- Select "合同档案" as 目标表,合同编号,己方主体 as 主体 from "合同档案"
- union all
- Select "过票合同档案" as 目标表,合同编号,甲方主体 as 主体 from "过票合同档案"
- union all
- Select "过票合同档案" as 目标表,合同编号,乙方主体 as 主体 from "过票合同档案"
- union all
- Select "过票合同档案" as 目标表,合同编号,丙方主体 as 主体 from "过票合同档案"
- union all
- Select "过票合同档案" as 目标表,合同编号,丁方主体 as 主体 from "过票合同档案"
- union all
- Select "过票合同档案" as 目标表,合同编号,戊方主体 as 主体 from "过票合同档案"
- union all
- Select "过票合同档案" as 目标表,合同编号,己方主体 as 主体 from "过票合同档案"
- )
- select * from cte as a
|
