select * from
(( orde o  left join orderproduct op on o.orderNum=op.orderNum )
inner join product p on op.proNum=p.productnum)  where p.id<10000
union
select * from
(( orde o  left join orderproduct op on o.orderNum=op.orderNum )
inner join product p on op.proNum=p.productnum)  where p.id<20000 and p.id>=10000
union
select * from
(( orde o  left join orderproduct op on o.orderNum=op.orderNum )
inner join product p on op.proNum=p.productnum)  where p.id>20000   ---???????дp.id>100 ???????????????????
----------------------------------??????????????-----------------------------------------
select * from
(( orde o  left join orderproduct op on o.orderNum=op.orderNum )
inner join product p on op.proNum=p.productnum)

 

?????????Ч??????????????????????±?????á??????????е???????????????????????????????????????????????????????????????????????Ч?????union????????????????????????????У?????union all?????union all???union??????????????