17,086
社区成员
发帖
与我相关
我的任务
分享
select a.order_id,m_id,tel from
(select order_id, m_id ,row_number() over(order by order_id) rn from order_mid) a
left join (select order_id, tel ,row_number() over(order by order_id) rn from order_tel) b on a.order_id=b.order_id and a.rn=b.rn
select a.order_id,a.tel,b.pp_id from a a,b b where a.order_id=b.order_id