select bioRecord_base.* 
into bioRecord_base
from syn2_world.dbo.bioRecord_base
join syn2_world.dbo.institution_code on institution_code_id = id
where institution_code = 'BGBM';

select bioRecord_ext.*
into bioRecord_ext
from bioRecord_base
join syn2_world.dbo.bioRecord_ext on brKey = bioRecordKey;