Results 1 to 3 of 3

Thread: SQL Question

  1. #1
    Join Date
    Oct 2003

    Unanswered: SQL Question

    I have a query:

    select b.operator_id, a.trade_code
    from rhm_operator_trades a, rhm_operators b
    where b.operator_id = a.operator_id
    and b.operator_id = '90177'

    which returns:

    90177 38
    90177 45
    90177 50

    Is it possible to get the following output from an SQL query
    90177 38,45,50

    i.e. all the trade codes are concatenated onto one row, against the corresponding operator id record.

    I can produce this result in a PL/SQL loop, but I really need to get this output from a single SQL query and I can for the life of me see how it could be done.
    So any help would be appreciated.

  2. #2
    Join Date
    Oct 2003
    By the wat this is on an Oracle DB

  3. #3
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    It was discussed on the Oracle Forum just a few days ago. Read more about it here.

Posting Permissions

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