sql拼接字段concat

concat 拼接字段

原本sql是查询两个公司名称，但是后面改为查相关公司的名称，但是再新增字段不改变，所以再sql查询字段修改为将两个公司拼接，原sql为

SELECT * FROM
(SELECT
	cin.* ,
	er1.enterprise_name as party_a_name,
	er2.enterprise_name as party_b_name,
	su.realname as resp_name,
	sd.depart_name as dep_name
FROM
	contract_inner cin
	left join
	enterprise_roster er1 on er1.id = cin.party_a
	left join
	enterprise_roster er2 on er2.id = cin.party_b
	left join
	sys_user su on su.id = cin.resp_id
	left join 
	sys_depart sd on sd.id = cin.dep_id
	) ci

后面使用concat拼接partyA和partB两个字段

SELECT
	*,
	CONCAT( party_a_name, ',', party_b_name ) AS party_name 
FROM
	( SELECT
	cin.* ,
	er1.enterprise_name as party_a_name,
	er2.enterprise_name as party_b_name,
	su.realname as resp_name,
	sd.depart_name as dep_name
FROM
	contract_inner cin
	left join
	enterprise_roster er1 on er1.id = cin.party_a
	left join
	enterprise_roster er2 on er2.id = cin.party_b
	left join
	sys_user su on su.id = cin.resp_id
	left join 
	sys_depart sd on sd.id = cin.dep_id
	 ) t

其中在CONCAT( party_a_name, ',', party_b_name ) AS party_name 中的意思为：
将party_a_name和party_b_name拼接，中间使用“，”隔开，合成的新字段名称为party_name