Results 1 to 2 of 2

Thread: Query Result

  1. #1
    Join Date
    Oct 2008
    Posts
    82

    Cool Unanswered: Query Result

    Hi Experts,

    I am not good in sql and received an ticket ..

    Here is the ticket Details :

    There is a table with two columns

    ID Value
    a a
    b a
    c b
    d b

    Now they need the result in one column and output have to be

    Result
    aa
    ba
    cb
    db

    They dont need any spaces betwwen letters in the result.

    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Concatenate the columns to form one column.

    Andy

Posting Permissions

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