参考来自:http://bbs.csdn.net/topics/390737006
1.效果演示
(1)不做处理
(2)合并多列,并对后四列的值做并集处理
2.SQL语句
(1)不做处理
1 SELECT 2 C .fd_tenantid AS fdTenantId, 3 C .fd_resid AS fdResid, 4 C .fd_res_name AS fdResName, 5 C .fd_service AS fdService, 6 b.fd_get AS fdGET, 7 b.fd_post AS fdPOST, 8 b.fd_put AS fdPUT, 9 b.fd_delete AS fdDELETE 10 FROM