How do I add a column that combines several entries RRS feed

  • Question

  • I have two tables that I want to join.  It is a one to many.  I would like the results of the many put into one column with a comma seperating each value.

    Here is an example of the one table:

    Make Model
    Chevy Camaro
    Chevy Corvette
    Ford Mustang
    Ford Taurus
    Honda Civic
    Honda  Accord

    When I join this with another table, I would like the results to look like this:

    Make Models
    Chevy Camaro, Corvette
    Ford Mustang, Taurus
    Honda Civic, Accord

    Thank you for any and all help.  I'm still new at this.

    Thursday, February 10, 2011 6:43 PM


All replies