The SELECT work order number, product name,
Product specifications=STUFF
((SELECT + '[' + + product specifications']'
The FROM (SELECT GD FBillNo work order number, FZ, FName specifications FROM t_BOS_SCGD GD
INNER JOIN t_BOS_SCGDEntry GDE ON GD. FID=GDE. FID
INNER JOIN t_Item WL ON GDE. FBase4=WL. FItemID
INNER JOIN t_AuxItem FZ ON GDE. FFZSX=FZ. FItemID
WHERE FBillNo='06 pe201012500) b
FOR XML PATH (')), 1, 1, ' ')
The FROM (SELECT DISTINCT GD. FBillNo work order number, WL. FName product name FROM t_BOS_SCGD GD
INNER JOIN t_BOS_SCGDEntry GDE ON GD. FID=GDE. FID
INNER JOIN t_Item WL ON GDE. FBase4=WL. FItemID
WHERE FBillNo='06 pe201012500) a
GROUP BY work order number, product name
