drop table if exists #t1, #t2;

create table #t1 (val1 varchar(255), val2 varchar(255));
create table #t2 (val varchar(255));

insert into #t1
exec value1;

insert into #t2
exec value2;

insert into #t2
exec value3;

insert into #t2
exec value4;

insert into #t2
  select val1 from #t1;

drop table if exists #t1, #t2, #t3, #t4;
create table #t1 (id int identity(1, 1), val1 varchar(255), val2 varchar(255));
create table #t2 (id int identity(1, 1), val varchar(255));
create table #t3 (id int identity(1, 1), val varchar(255));
create table #t4 (id int identity(1, 1), val varchar(255));

insert into #t1 (val1, val2)
exec value1; 

insert into #t2 (val)
exec value2;

insert into #t3 (val)
exec value3;

insert into #t4 (val)
exec value4;


select
        t1.val1, 
        t1.val2,
        t2.val,
        t3.val,
        t4.val
from #t1 t1
join #t2 t2 on t2.id = t1.id
join #t3 t3 on t3.id = t1.id
join #t4 t4 on t4.id = t1.id