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   

Edited by tanu - 28 Jun 2011 at 11:33am