有谁解决了这个问题吗?麻烦告知一下
department_copy表与department_copy1表的字段是一样的
定义的视图脚本是这样的,脚本没毛病吧???
SELECT
COALESCE(department_copy
.id
,department_copy1
.id
) AS id
,
COALESCE(department_copy
.dep_name
,department_copy1
.dep_name
) AS dep_name
,
COALESCE(department_copy
.parent_dep_id
,department_copy1
.parent_dep_id
) AS parent_dep_id
,
COALESCE(department_copy
.org_id
,department_copy1
.org_id
) AS org_id
,
COALESCE(department_copy
.special
,department_copy1
.special
) AS special
,
COALESCE(department_copy
.order_no
,department_copy1
.order_no
) AS order_no
,
COALESCE(department_copy
.create_time
,department_copy1
.create_time
) AS create_time
,
COALESCE(department_copy
.modify_time
,department_copy1
.modify_time
) AS modify_time
FROM
department_copy
LEFT JOIN department_copy1
ON department_copy
.id
= department_copy1
.id
UNION
SELECT
COALESCE(department_copy
.id
,department_copy1
.id
) AS id_1
,
COALESCE(department_copy
.dep_name
,department_copy1
.dep_name
) AS dep_name1
,
COALESCE(department_copy
.parent_dep_id
,department_copy1
.parent_dep_id
) AS parent_dep_id
,
COALESCE(department_copy
.org_id
,department_copy1
.org_id
) AS org_id
,
COALESCE(department_copy
.special
,department_copy1
.special
) AS special
,
COALESCE(department_copy
.order_no
,department_copy1
.order_no
) AS order_no
,
COALESCE(department_copy
.create_time
,department_copy1
.create_time
) AS create_time
,
COALESCE(department_copy
.modify_time
,department_copy1
.modify_time
) AS modify_time
FROM
department_copy
RIGHT JOIN department_copy1
ON department_copy
.id
= department_copy1
.id
2020-12-17
最新推荐文章于 2024-06-26 21:49:41 发布