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_IDGROUP BY BMS_EXPORT.INDX

合并前：

合并后效果：