I have this table structure

```
ProjectExpenses Table:
--------------------------------------
ProjectName    Expense     Currency
--------------------------------------
Foo            10          USD
Foo            20          USD
Foo            100         JPY
Bar            50          EUR
Bar            25          EUR

```

I definitely want to group by ProjectName; that much I know but how can I get an output like this

```
--------------------------
ProjectName    AllExpenses
--------------------------
Foo            30 USD, 100 JPY
Bar            75 EUR,

```

I'm looking for a string joining function but I have no clue where to begin looking or even if something like this is possible with just a sql query.

Any hints as to how to solve this problem would be very much appreciated.