SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) / how to concatenate rows and join in another table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:06:45 GMT20RE: how to concatenate rows and join in another tablehttp://www.sqlservercentral.com/Forums/Topic1407711-392-1.aspxHi Welcome to SSC forum, please Dont cross post , it waste the time of people the original thread is [url]http://www.sqlservercentral.com/Forums/Topic1407712-392-1.aspx[/url]Wed, 16 Jan 2013 03:38:29 GMTBhuvneshhow to concatenate rows and join in another tablehttp://www.sqlservercentral.com/Forums/Topic1407711-392-1.aspxHi to all,Please bear with me. anyways, this is the tables i haveTable1Name Company IDMike ABC 1Joey CBA 2Table2OtherVisaID TypeID Remarks1 1 test11 2 test22 3 test32 2 test42 1 test5Table3TypeID Description1 US2 UK3 SGResult should be like this..ID Name Company List of Visa 1 Mike ABC US;UK 2 Joey CBA US;UK;SGso as you can see it was separated by ";" hope you understand my question..thanks in advance.Wed, 16 Jan 2013 03:02:24 GMTernesto.yandoc