Hi,

Can you please tell me how to concatenate multiple row colums into one??
My Report consists of several tables joined by their User Id.....so i have to link all of them with left outer join.

For Example,

Users.UserID Info.Mobile Company.M0dels
1 Samsung 1
1 Nokia 2
2 Nokia 3
2 LG 4

changes into

Users.UserID Info.Mobile Company.Models
1 Samsung,Nokia 1,2
2 Nokia,LG 3,4

Here, Users, Info & Company are different tables left joined to Users..

Please help mee...asap