Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Binary Universe
    Posts
    57

    Unanswered: Miltiple fields in the same column.

    Is there a way to concatenate two fields with the same criteria in the same column using SQL statement? There's more then one [Request ID] (Col2) for the same [Invoice Number] (Col1). The desired output is:

    Col1 | Col2
    [22] | [12 21] <--- these [Request ID]s are from two different records

    I tried subquery for Col2 (SELECT ...) but it can only return one record ([Request ID]) at a time.

    Thanks.
    I won't byte... hard!

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Like this

    Code:
    SELECT col1 & Col2 as JoinedCol
    FROM Tblname;
    Dave

Posting Permissions

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