declare @science table 
(name varchar(2),[count] int,other varchar(3))
insert into @science
select 'a1',5,'aa1' union all
select 'a2',6,'aa2'

declare @super table (name varchar(2),sey int)
insert into @super
select 'b1',5 union all
select 'b2',6

insert into @science(name) select name from @super

select * from @science
/*
name count       other
---- ----------- -----
a1   5           aa1
a2   6           aa2
b1   NULL        NULL
b2   NULL        NULL
*/