Group Concatenate in SAP MII MDO
I want to concatenate all the values of column in a single row with GROUP BY Clause. For Example:
SELECT id, subject, GROUP_CONCAT(username SEPARATOR ', ') usernames FROM some_table GROUP BY id, subject
How can I g about performing a similar function in SAP MII SELECT MDO Query?