数据库一列拼接成一个字符串
sqlserver:
SELECT
*,
( SELECT Hospitalproperty2 + ' ' FROM testtable WHERE Hospitalproperty = 'zhangs' FOR XML path ( '' ) )
FROM
testtable
MySQL:
select *,(select GROUP_CONCAT(b.Hospitalproperty2)from testtable b) from testtable;