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!
**elinore**
---------------------
"The most powerful weapon on earth,
is the human soul on fire" - Ferdinand Foch