1. Forum
  2. USENET
  3. comp.databases.ms-sqlserv

  • Query to merge group heading to a column

    From miloann@miloann2002@yahoo.com to comp.databases.ms-access on Tue Oct 17 11:30:56 2023
    From Newsgroup: comp.databases.ms-sqlserv

    Example:
    AAA
    123 John Los Angeles
    222 Lee Los Angeles
    BBB
    456 Mary New York
    555 Ann Houston
    CCC
    789 David Phoenix

    How to write a query to become:
    AAA 123 John Los Angeles
    AAA 222 Lee Los Angeles
    BBB 456 Mary New York
    BBB 555 Ann Houston
    --- Synchronet 3.21d-Linux NewsLink 1.2