select
    1 as id
into
    #t1
union all
select
    2 as id;
    
select
    1 as id,
    'White Rabbit' as name_
into
    #t2
union all
select
    1 as id,
    'Black Magic' as name_
union all
select
    2 as id,
    'We Follow' as name_
union all
select
    2 as id,
    'By Alice' as name_;
    
select
    t1.id
    , t2.name_
from
    #t1 t1
cross apply (select top 1 name_ from #t2 t2 where t2.id = t1.id) t2;

select
    t.id
    , t.name_
from
    (
        select
            t1.id
            , t2.name_
            , row_number() over(partition by t1.id order by t1.id) rn_
        from
            #t1 t1
        inner join #t2 t2 on
            t2.id = t1.id
    ) t
where
    t.rn_ = 1;
    
select top 1 with ties
    t1.id
    , t2.name_
from
    #t1 t1
inner join #t2 t2 on
    t1.id = t2.id
order by
    row_number() over(partition by t1.id order by t1.id);