Many rows to one column...

[ckabi]

I thought this would be very simple, but I can't seem to figure it out ...

from this table:
phID usID phone
1 1 555-1212
2 1 555-2121
3 2 555-9955

I want this view:
usID calcphones
1 555-1212 555-2121
2 555-9955

where calcphones is a calculated column.
How can I do this?

 

[JamesLean]

This depends on the DBMS you are using, eg in SQL Server you would create a user defined function that took a userid as inpuit and returned the concatenated list of numbers.

--James