How to combine two rows

• Ashwin9

  SSC-Addicted

  Points: 477

  More actions

  March 3, 2011 at 3:18 am

  #97803

  My Table is like this ---

  Id Name Class Subject

  ---------------------------------

  2 Sam 12 English

  2 Sam 10 Maths

  2 Sam 10 English

  2 Sam 8 History

  Here Sam teaches Class 12 - English, Class 10 - Maths & English, Class 8 - History

  I want to display the result like this -

  Id Name Class Subject

  ---------------------------------

  2 Sam 12 English

  2 Sam 10 Maths, English

  2 Sam 8 History

  How to combine two Rows ?

  Thanks in Adv...

  Ashwin

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  March 3, 2011 at 4:08 am

  #1293909

  Homework ?

  Try this article

  http://www.sqlservercentral.com/articles/comma+separated+list/71700/

  ---

  
  Clear Sky SQL
  My Blog[/url]