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

[sql] 
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