declare @t1 table (person_id int, col1 varchar(1))
insert into @t1 values(11, 'a'), (12, 'b')

declare @t2 table (person_id int, col2 varchar(1))
insert into @t2 values(21, 'b'), (22, 'c')

declare @t3 table (person_id int, col3 varchar(1))
insert into @t3 values(31, 'd'), (32, 'b')

declare @person table(person_id int, fio varchar(100))
insert into @person values(11, 'Ivanov'), (12, 'Petrov'),(21, 'Sidorov'), (32, 'Kakashkin')


select p1.fio, t1.col1, p2.fio, t2.col2, p3.fio, t3.col3
from @t1 t1 left join @t2 t2 on t1.col1 = t2.col2
            left join @t3 t3 on t1.col1 = t3.col3
            left join @person p1 on t1.person_id = p1.person_id            
            left join @person p2 on t2.person_id = p2.person_id            
            left join @person p3 on t3.person_id = p3.person_id