select*frombrewmgr.brewwherePARTNOin(SELECTa.PARTNOFROMbrewmgr.BREWaLEFTOUTERjoinbrew... select * from brewmgr.brew where PARTNO in (
SELECT a.PARTNO FROM brewmgr.BREW a
LEFT OUTER join brewmgr.plan_list b ON a.PARTNO=b.PARTNO
LEFT OUTER join brewmgr.BREW_ITEMID c ON a.PARTNO=c.PARTNO
where a.checkok=1 and upper(a.isonline)=0
group by a.PARTNO
) limit 2,20
如果去掉limit就正确。请帮帮
在oracl数据库中