Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table1 as
     select 1 as company_number from dual
1 rows affected

create table table2 as
    select 1 as company_number, 'abc' as address from dual
1 rows affected

select t1.*, t2.*
from table1 t1 left join lateral
     (select t2.*
      from table2 t2
      where t2.company_number = t1.company_number and rownum = 1
     ) t2
     on 1=1;


COMPANY_NUMBER
COMPANY_NUMBER
ADDRESS


1
1
abc


    select t1.*, t2.*
    from table1 t1 left join lateral
         (select t2.*,
                 row_number() over (partition by company_number order by dbms_random.random) as seqnum
          from table2 t2
         ) t2
         on t2.company_number = t1.company_number and
            seqnum = 1;
            


COMPANY_NUMBER
COMPANY_NUMBER
ADDRESS
SEQNUM


1
1
abc
1