SELECT  
T1.[ORDER_NO] AS 订单号
,T1.[INVENTORY_NO] AS 存货编码
,T1.[INVENTORY_NAME] AS 存货名称
,T2.[LASTMODIFY_DATE] AS 报检时间
,T3.[PLANCHECK_DAY] AS 计划检测天数
,ISNULL(T1.EXCEPTION_EVENT,‘‘) AS 订单异常事件
,
‘"‘+
ISNULL(( 
	SELECT STUFF(
	(
		SELECT ‘ ‘ + [CHECK_EVENT] FROM 
		(
			SELECT ( ‘检验事件‘+ cast(Row as nvarchar(5)) + ‘:‘   + [CHECK_EVENT] + ‘   ‘+char(10)) AS [CHECK_EVENT] FROM
			(
				SELECT  ROW_NUMBER()over(order by [ID]) Row, [CHECK_EVENT]  
				FROM [TB_OQCMEMBER] AS TMP_TB1 WHERE TMP_TB1.OACPLAN_ID = T3.ID
			) AS TT
		) AS  #temp for xml path(‘‘)
	), 1, 1, ‘‘)
),‘‘)
+‘"
‘ AS 检验事件
FROM  [TB_ORDER_BASE] AS T1
LEFT JOIN [TB_ASSEMBLY] AS T2 ON T1.ORDER_ID = T2.ORDER_ID
LEFT JOIN [TB_OQC] AS T3 ON T2.ASSEMBLY_ID = T3.ASSEMBLY_ID