Select
...
row_number() over (...) as num
from tbl1
join (
 Select *
 from tbl2
 where < условия>
 for key share
) as t on t.id=tbl1.f_id