selecting rows

• pzmrcd

  Default port

  Points: 1419

  More actions

  November 23, 2005 at 3:15 pm

  #115612

  Hi

  I have a table t1 with cols ID and text.

  So when I do a select * from t1 where ID=10

  I get two rows

  ID    TEXT

  10     AA

  10     BB

  Is there a way I can get back these two records as one record like

  ID            TEXT

  10           AA,BB

   

  Thanks

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  November 23, 2005 at 8:13 pm

  #605610

  See "How do I concatenate strings from a column into a single row?" at http://www.aspfaq.com/show.asp?id=2529

  SQL = Scarcely Qualifies as a Language