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.
