hi. my friend posed me this problem. is there a select statement with multiple values returned on a single result set field?

here is a sample of what he meant:

table1
ID Cust
--- ----
11 AAA
12 BBB
13 CCC

table2
ID Prod
--- ----
11 MMM
11 NNN
12 MMM
12 NNN
12 OOO
13 MMM
13 OOO

is there a query possible to return this result set?

ID Cust Prod
--- ---- --------------
11 AAA MMM, NNN
12 BBB MMM, NNN, OOO
13 CCC MMM, OOO


if anyone could enlighten me, i would appreciate this very much! thanks in advance!