2020-12-17

有谁解决了这个问题吗？麻烦告知一下


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