Master-Detail 查询 表体字符串归拢

Master-Detail 查询 表体字符串合并

SELECT  BMS_EXPORT.INDX ,
        DELIVERY_NO = STUFF(( SELECT    DISTINCT '/' + BED.DELIVERY_NO
                              FROM      BMS_EXPORT BE
                                        INNER JOIN DBO.BMS_EXPORT_D BED ON BE.INDX = BED.BMS_EXPORT_ID
                              WHERE     BE.INDX = BMS_EXPORT.INDX
                            FOR
                              XML PATH('')
                            ), 1, 1, '')
FROM    BMS_EXPORT
        INNER JOIN DBO.BMS_EXPORT_D ON BMS_EXPORT.INDX = BMS_EXPORT_D.BMS_EXPORT_ID
GROUP BY BMS_EXPORT.INDX

合并前：

合并后效果：