create view test as
select *
from
  firsttable f
inner
join  ( select *
    , row_number() as rownum
    from
      secondtable s
   ) as t

on    f.id = t.id

create view test as
select *
from
  firsttable f
inner
join  ( select s.*
    , row_number() as rownum
    from
      secondtable s
   ) as t

on    f.id = t.id