I have been using Confio Ignite for about a year and half and it is wonderful. I tested many and this was the easiest to setup with virtually no...

Try this

Select a.grp,sum(a.amount), b.ledgers From tbl a

join (

SELECT c.grp, ledgers = c.ledger + ',' + c.ledger

FROM tbl c...