select * from
(select rownum rn, t1.* from t1),
(select rownum rn, t2.* from t2)
(select rownum rn, t1.* from t1),
(select rownum rn, t2.* from t2)
where rn = rn;
========================================================
select * from
(select su.id,su.user_name from S_USER su,S_WHOLESALER sw where su.id=sw.handler_id) m,
(select sw.handler_id,sw.id, su.user_name, sw.name,sw.status,sw.create_time from S_USER su,S_WHOLESALER sw where su.id=sw.user_id) n
where m.id=n.handler_id