mysql 多个字段拼接

SELECT    
CONCAT(IFNULL(d.NATION_CN_NM,''),IFNULL(c.CT_NAME,''),IFNULL(b.CT_NAME,''),
IFNULL(a.CT_NAME,'')) AS mchtAddr
FROM
CT_BASE_INFO a 
LEFT JOIN CT_BASE_INFO b ON a.UP_CANTON_CODE = b.CANTON_CODE
LEFT JOIN CT_BASE_INFO c ON b.UP_CANTON_CODE = c.CANTON_CODE
LEFT JOIN BASE_NATION_INFO d ON a.CTS_FLAG = d.NATION_CTS_NO
WHERE a.CANTON_CODE = '820008';

SELECT    
CONCAT_WS('-'IFNULL(d.NATION_CN_NM,''),IFNULL(c.CT_NAME,''),IFNULL(b.CT_NAME,''),
IFNULL(a.CT_NAME,'')) AS mchtAddr
FROM
CT_BASE_INFO a 
LEFT JOIN CT_BASE_INFO b ON a.UP_CANTON_CODE = b.CANTON_CODE
LEFT JOIN CT_BASE_INFO c ON b.UP_CANTON_CODE = c.CANTON_CODE
LEFT JOIN BASE_NATION_INFO d ON a.CTS_FLAG = d.NATION_CTS_NO
WHERE a.CANTON_CODE = '820008'