Concatenating multiple rows into 1 row

[houseofturner]

I have a query which simply returns

Company Name and Account Number.

However, because the same company can have multiple Account Numbers I want to have one row for each Company with each account number separated by a comma

So instead of

Company A Account Number 1
Company A Account Number 2
Company A Account Number 3

I want

Company A Account Number 1, Account Number 2, Account Number 3

Any help would be appreciated.

 

[Kiwiman]

Howzit

See this from Allen Browne