SELECT st_union(geom)
from
(select geom from department_info where id = '×××××公司'
UNION ALL
select geom from department_info where id = '×××××公司'
UNION ALL
select geom from department_info where id = '×××××公司'
UNION ALL
select geom from department_info where id = '×××××公司'
UNION ALL
select geom from department_info where id = '×××××公司'
UNION ALL
select geom from department_info where id = '×××××公司'
UNION ALL
select geom from department_info where id = '×××××公司') as foo
执行结果:
SELECT st_union(geom)
from
(select geom from department_info where pid = '×××××公司') as foo