[原创]some SQL

_select orderdetail4 from Orderdetailinfo4 orderdetail4,Orderinfo2 order2  where orderdetail4.orderid=order2.id and order2.objstatus<>’2’ and orderdetail4.objcount>0 and  not exists(_select orderdetail3.orderdetail2id from Orderdetailinfo3 orderdetail3 where orderdetail4.orderdetail2id=orderdetail3.orderdetail2id and orderdetail3.orderid is null and orderdetail3.curuserid=’40288a7d0d73406a010d7ccbc00f15dd’) and  not exists (_select ’X’ from Delobj del where orderdetail4.id=del.objid and del.objtable=’Orderdetailinfo4’) 

_select orderdetai0_.id as id377_, orderdetai0_.orderid as orderid377_, orderdetai0_.orderid2 as orderid3_377_, orderdetai0_.orderdetail2id as orderdet4_377_, orderdetai0_.curuserid as curuserid377_, orderdetai0_.objcount as objcount377_, orderdetai0_.pm33 as pm7_377_, orderdetai0_.pm34 as pm8_377_, orderdetai0_.pm35 as pm9_377_, orderdetai0_.pm36 as pm10_377_, orderdetai0_.pm37 as pm11_377_, orderdetai0_.pm38 as pm12_377_, orderdetai0_.pm39 as pm13_377_, orderdetai0_.pm40 as pm14_377_, orderdetai0_.pm41 as pm15_377_, orderdetai0_.pm42 as pm16_377_, orderdetai0_.pm43 as pm17_377_, orderdetai0_.pm44 as pm18_377_, orderdetai0_.pm45 as pm19_377_, orderdetai0_.pm46 as pm20_377_, orderdetai0_.pm47 as pm21_377_, orderdetai0_.pm48 as pm22_377_, orderdetai0_.tsm as tsm377_, orderdetai0_.objdesc as objdesc377_, orderdetai0_.col1 as col25_377_, orderdetai0_.col2 as col26_377_, orderdetai0_.col3 as col27_377_ from orderdetailinfo4 orderdetai0_, orderinfo2 orderinfo2x1_ where orderdetai0_.orderid=orderinfo2x1_.id and orderinfo2x1_.objstatus<>’2’ and orderdetai0_.objcount>0 and  not (exists (_select orderdetai2_.orderdetail2id from orderdetailinfo3 orderdetai2_ where orderdetai0_.orderdetail2id=orderdetai2_.orderdetail2id and (orderdetai2_.orderid is null) and orderdetai2_.curuserid=’40288a7d0d73406a010d7ccbc00f15dd’)) and  not (exists (_select ’X’ from delobj delobj3_ where orderdetai0_.id=delobj3_.objid and delobj3_.objtable=’Orderdetailinfo4’))

推荐到鲜果：