mysql拼接字段

SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'weight' AS `CODE`,
	'体重' AS `NAME`,
	'ehs_everyday_weight' AS `tableCode`,
	a.measured_time,
   CONCAT(' 体重:',IFNULL(a.weight,'-'),'kg',' 身高:',IFNULL(a.height,'-'),' BIM:',IFNULL(a.bmi,'-') ) AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_weight a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
		UNION ALL

SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'bloodGlucose' AS `CODE`,
	'血糖' AS `NAME`,
	'ehs_everyday_blood_glucose' AS `tableCode`,
	a.measured_time,
CASE
		WHEN a.measured_type = 1 THEN
		CONCAT( '空腹血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 2 THEN
		CONCAT( '早餐后2小时血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 3 THEN
		CONCAT( '午餐前血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 4 THEN
		CONCAT( '午餐后2小时血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 5 THEN
		CONCAT( '晚餐前血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 6 THEN
		CONCAT( '晚餐后2小时血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 7 THEN
		CONCAT( '睡前或夜间血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 8 THEN
		CONCAT( '随机血糖：', a.blood_glucose ) 
		WHEN a.measured_type = 9 THEN
		CONCAT( '餐前血糖：', a.blood_glucose ) ELSE '' 
	END AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_blood_glucose a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
	UNION ALL

SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'bloodPressure' AS `CODE`,
	'血压' AS `NAME`,
	'ehs_everyday_blood_pressure' AS `tableCode`,
	a.measured_time,
	CONCAT( '血压：', a.systolic_pressure, '/', a.diastolic_pressure, '  心率：', a.sphygmus ) AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_blood_pressure a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
	
	UNION ALL

		
		
		SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'uricAcid' AS `CODE`,
	'尿酸' AS `NAME`,
	'ehs_everyday_uric_acid' AS `tableCode`,
	a.measured_time,
   CONCAT('尿酸:',a.uric_acid) AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_uric_acid a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
	UNION ALL
	
	
	SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'bloodFat' AS `CODE`,
	'血脂' AS `NAME`,
	'ehs_everyday_blood_fat' AS `tableCode`,
	a.measured_time,
   CONCAT('总胆固醇(TC):',IFNULL(a.tc,'-'),' 甘油三酯(TG):',IFNULL(a.tg,'-'),' 高密度脂蛋白胆固醇(HDL-C):',IFNULL(a.hdl,'-'),' 低密度脂蛋白胆固醇(LDL-C):',IFNULL(a.ldl,'-')) AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_blood_fat a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
	UNION ALL
	
	SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'waistHipRate' AS `CODE`,
	'腰臀比' AS `NAME`,
	'ehs_everyday_waist_hip' AS `tableCode`,
	a.measured_time,
   CONCAT('腰围:',IFNULL(a.waistline,'-'),' 臀围:',IFNULL(a.hipline,'-'),' 腰臀比:',IFNULL(a.whr,'-')) AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_waist_hip a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
	UNION ALL
	
	
	SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'bodyTemperature' AS `CODE`,
	'体温' AS `NAME`,
	'ehs_everyday_body_temperature' AS `tableCode`,
	a.measured_time,
   CASE
		WHEN a.measuring_way = 1 THEN
		CONCAT( '标准体温', '', IFNULL(a.body_temperature,'-') ) 
		WHEN a.measuring_way = 2 THEN
		CONCAT( '口腔体温：', IFNULL(a.body_temperature,'-') ) 
		WHEN a.measuring_way = 3 THEN
		CONCAT( '直肠体温：', IFNULL(a.body_temperature,'-') ) 
		WHEN a.measuring_way = 4 THEN
		CONCAT( '腋下体温：', IFNULL(a.body_temperature,'-') ) 
	  ELSE '' 
	END AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_body_temperature a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1' 
	
	UNION ALL
	
	SELECT
	a.id AS id,
	`a`.`staff_id` AS `staffId`,
	'bloodOxygen' AS `CODE`,
	'血氧' AS `NAME`,
	'ehs_everyday_blood_oxygen' AS `tableCode`,
	a.measured_time,
		CONCAT( '血氧:', IFNULL(a.blood_oxygen,'-'),' 心率:',IFNULL(a.heart_rate,'-') )  AS result,
	da.id AS dataId 
FROM
	hms_abnormal_data da
	LEFT JOIN ehs_everyday_blood_oxygen a ON a.id = da.report_id 
WHERE
	a.id != '' 
	AND a.id IS NOT NULL 
	AND a.del_flag = '0' 
	AND da.is_dispose = '1'