内容如下：
select p.KeyId,
stuff((SELECT ',' + CONVERT(nvarchar, KeyId) FROM dbo.QR_Inspection WHERE propertyId = p.KeyId FOR xml path('')),1,1,'') AS iid,
stuff((SELECT ',' + CONVERT(nvarchar, KeyId) FROM dbo.QR_User WHERE propertyId = p.number FOR xml path('')),1,1,'') AS uid
from dbo.QR_Property p
order by KeyId descPs：MySql中可直接用group_concat函数实现。
Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4
