SELECT
a.ItemNumber
BoxNumber = REPLACE(
(
SELECT
BoxNumber AS [data()]
FROM
shipmenttable c
WHERE
c.ItemNumber = b.ItemNumber
ORDER BY
c.ItemNumber
FOR XML PATH ('')
), ' ', ','),
Max(b.DateShipped)
FROM
Ordertable a
Inner join shipmenttable b on a.ItemNumber = b.ItemNumber
group by a.ItemNumber
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
,MAX (ShipDate)
FROM urTable b
GROUP BY ItemNumber