SELECT 楼盘名称 ,
CONVERT(XML, '<图片信息>'
+ ( SELECT T1.图片名称
FROM [Copycat.DataResources.Database].[dbo].[运维中心_楼盘_图片_配置] AS T1
WHERE T1.运维中心_楼盘_数据_Guid = C.Guid
FOR
XML PATH('image')
) + '</图片信息>') AS 图片信息 ,
FROM [Copycat.DataResources.Database].[dbo].[运维中心_楼盘_数据] AS C
WHERE EXISTS ( SELECT TOP 1
1
FROM [Copycat.DataResources.Database].[dbo].[运维中心_楼盘_图片_配置]
AS T2
WHERE T2.运维中心_楼盘_数据_Guid = C.Guid )
CONVERT(XML, '<图片信息>'
+ ( SELECT T1.图片名称
FROM [Copycat.DataResources.Database].[dbo].[运维中心_楼盘_图片_配置] AS T1
WHERE T1.运维中心_楼盘_数据_Guid = C.Guid
FOR
XML PATH('image')
) + '</图片信息>') AS 图片信息 ,
FROM [Copycat.DataResources.Database].[dbo].[运维中心_楼盘_数据] AS C
WHERE EXISTS ( SELECT TOP 1
1
FROM [Copycat.DataResources.Database].[dbo].[运维中心_楼盘_图片_配置]
AS T2
WHERE T2.运维中心_楼盘_数据_Guid = C.Guid )