select pur_price,sal_price,fanli_price,ywyc_price from oa_one_pro where id in( select one_pro_id from oa_one_pro_status a , oa_event_sales b where a.project_id=b.id and b.oid = 订单号 );
5.select tcyc_price,butie_price from cs_pro_info where pro_no =4中查到的product_id select tcyc_price,butie_price from cs_pro_info where pro_no in ( select produt_id from oa_one_pro where id in( select one_pro_id from oa_one_pro_status a , oa_event_sales b where a.project_id=b.id and b.oid = 订单号 ) )
where project_id in (1的结果集)
其他的同理
from oa_one_pro
where id in(
select one_pro_id
from oa_one_pro_status a , oa_event_sales b
where a.project_id=b.id
and b.oid = 订单号
);
select tcyc_price,butie_price
from cs_pro_info
where pro_no in (
select produt_id from oa_one_pro
where id in(
select one_pro_id
from oa_one_pro_status a , oa_event_sales b
where a.project_id=b.id
and b.oid = 订单号
)
)