SELECT
    t1.OtherVisaID, 
    t1.Name,
    t1.Company,
    STUFF( (SELECT ';' + t3.Description
            FROM Table2 as t2
            JOIN Table3 as t3
                ON t3.OtherVisaID = t2.OtherVisaID
            WHERE 
                t2.OtherVisaID = t1.OtherVisaID 
            FOR XML PATH(''), TYPE).value('.', 'varchar(max)')
            ,1, 1, '') as ListOfVisa,
FROM Table1 as t1

SELECT  t1.OtherVisaID,
        t1.Name,
        t1.Company,
        dbo.GROUP_CONCAT_D(t3.DESCRIPTION, ';') AS ListOfVisa
FROM    Table1 AS t1
        JOIN Table2 AS t2 ON t1.OtherVisaID = t2.OtherVisaID
        JOIN Table3 AS t3 ON t3.OtherVisaID = t2.OtherVisaID
GROUP BY t1.OtherVisaID,
        t1.Name,
        t1.Company;