67,550
社区成员




create table user_info{
id int primary key,
name varchar(20)
}
create table order_info{
id int primary key,
order_user_id int,
examine_user_id int
}
select
from
user_info user_info ,order_info order_info
select t2.*,
t1.name,
t1.name2
from (
select t1.id,
t1.name,
prior t1.id id2,
prior t1.name name2
from (
select t1.*,
count(1) over() cot
from user_info t1
) t1
connect by level < cot
) t1,
order_user t2
where t1.id = t2.order_user_id
and t1.id2 = t2.examine_user_id