Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: query on one line

    Hi,
    I've these tables:

    tab1:
    WR_ID
    1
    2
    3


    tab2:
    WR_ID......APPROV
    1............A1
    1............A2
    2............A22
    2............A34
    2............A44
    3............AAA

    I'd like this output:
    WR_ID......APPROV
    1............A1, A2
    2............A22, A34, A44
    3............AAA


    How can I write my query to get this output?

    Thanks!

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Search for stragg on this site: http://asktom.oracle.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •