我有一张表格,其中包含以下信息:
ITEM WH BATCH DOC NO
CLD1 FN B1 3
CLD1 FN B1 3
CLD1 FN B2 3
CLD1 FN B2 3
CLD1 FN B3 3
CLD1 FN B4 3
这是我用来获取上述值的代码:
select T0.item,t0.wh,t0.batchnum from oibt t0 where t0.DOCNO = '3' and t0.Wh = 'FN'
我需要类似于这样的输出:
ITEM WH BATCH
CLD1 FN B1,B2,B3,B4
我也使用了STUFF和For XML编码,但是我没有得到期望的输出结果。
FROM OIBT US WHERE US.DOCNUM = '3' AND US.Wh = 'FN' FOR XML PATH('')), 1, 1, '') [BATCH REF NO] from OIBT T0 WHERE T0.DOCNO = '3' AND T0.WH = 'FN' GROUP BY T0.ITEM,T0.WH,t0.Batch ORDER BY T0.Item```
- DeePak