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
合并前:
合并后效果: