I have a table in which following information are there:
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
This is the code which I have used to bring the above values:
select T0.item,t0.wh,t0.batchnum from oibt t0 where t0.DOCNO = '3' and t0.Wh = 'FN'
I need the output like this:
ITEM WH BATCH
CLD1 FN B1,B2,B3,B4
I have used STUFF & For XML coding too but I am not getting the desired output.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…