left join 后,去掉重复记录

t1 (a1,a2,a3)
1,a,a
2,b,b
3,c,c
4,d,d


t2 (b1,b2,b3)
e,e,1
f,f,2
f,f,3
a,a,4
f,f,4

e,x,1

select * from t1 left join
(
 select *
  from  
  (
  select a.*,row_number() over(partition by b3 order by b1) r
  from t2 a
  ) as tbl1
  where r = 1
) t2
on a1=b3