select 编号 COLLATE chinese_PRC_CI_AS_WS as 编号,名称 from aa union all select 代码,简称 COLLATE chinese_PRC_CI_AS_WS as 名称 from bb
select 编号 COLLATE chinese_PRC_CI_AS_WS as 编号,名称 COLLATE chinese_PRC_CI_AS_WS as 名称 from aa union all select 代码 COLLATE chinese_PRC_CI_AS_WS ,简称 COLLATE chinese_PRC_CI_AS_WS from bb
union all
select 代码,简称 COLLATE chinese_PRC_CI_AS_WS as 名称 from bb
union all
select 代码 COLLATE chinese_PRC_CI_AS_WS ,简称 COLLATE chinese_PRC_CI_AS_WS from bb