Merging Multiple Rows in Query

[Budfudder]

I have two (2) tables - Invoice and Product in my Microsoft Server DB. Each Invoice may have 1-n products, and each entry in the Product table has an Invoice ID which ties it back to the Invoice table.

I'm using a LEFT OUTER JOIN in my SQL statement to merge these tables into one, which works great - if there are two Products for a particular Invoice, I get two rows in the output, as I'd expect.

But what I want is to have only one row per Invoice in the result, and all of the Products for that Invoice to be concatenated together in a particular column (so that column would contain values like "Product 1, Product 2", "Product 1", "Product 2, Product 4" and so forth.

Is this possible using SQL?

[v-chuncz-msft · Accepted solution]

@Budfudder,

You may take a look at link below.

http://www.excelnaccess.com/concatenatex/