Seperate Foreign Key Table column value with comma (,)

• Sarfaraj Ahmed

  SSC-Addicted

  Points: 447

  More actions

  December 28, 2007 at 12:16 am

  #62935

  Hello EveryBody

  I have 3 tables. Customer, Order, CustomerOrder

  I want to write a query where my output should be below

  Cust_ID Order_ID

  C1001 101, 172, 193

  C1078 345, 789, 987, 989

  Any instruction will be really helpful

  ** if have any example please send me here or mail me sahmed1983@googlemail.com

  Thanks in advance

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  December 28, 2007 at 1:15 am

  #763161

  Sarfaraj Ahmed (12/28/2007)

  ---

  Hello EveryBody

  I have 3 tables. Customer, Order, CustomerOrder

  I want to write a query where my output should be below

  Cust_ID Order_ID

  C1001 101, 172, 193

  C1078 345, 789, 987, 989

  Any instruction will be really helpful

  ** if have any example please send me here or mail me sahmed1983@googlemail.com

  Thanks in advance

  Refer

  http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx

  ---

  Madhivanan

  Failing to plan is Planning to fail