combine cols from joined table onto one line?

• blueskies

  Newbie

  Points: 7

  More actions

  August 24, 2006 at 2:32 pm

  #92372

  I need to join two tables customers and ridedates. Each Customer may have taken one or more rides, in which case a row for each ride exists in the Ridedates table. I would like the result row to display the customer name info and all the ridedates from the joined table (could be comma delimited string).

  John Doe 7/4/2006,8/1/2006

  select c.name, r.ridedate from customer c join ridedates on c.uniqueid = r.uniqueid

  Any suggestions would be appreciated.

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  August 24, 2006 at 4:08 pm

  #656737

  Try this...

  I wasn't born stupid - I had to study.