oracle当然可以了,如下:
SELECT a.factivestate, b.furgestate, COUNT(*) fcount
FROM cotwfmworkitem a,cotwfmcasedata b,cotwfmprocedureinstance c
WHERE c.fid = a.fprocinstid
AND a.fprocinstid = b.fprocinstid(+)
AND a.fuserid = 0
AND (a.factivestate = 1 OR a.factivestate=3 OR a.factivestate = 5 )
AND c.fActiveState = 2
GROUP BY a.factivestate, b.furgestate
ORDER BY 3
SELECT a.factivestate, b.furgestate, COUNT(*) fcount
FROM cotwfmworkitem a,cotwfmcasedata b,cotwfmprocedureinstance c
WHERE c.fid = a.fprocinstid
AND a.fprocinstid = b.fprocinstid(+)
AND a.fuserid = 0
AND (a.factivestate = 1 OR a.factivestate=3 OR a.factivestate = 5 )
AND c.fActiveState = 2
GROUP BY a.factivestate, b.furgestate
ORDER BY 3
in oracle9i你不用该就可以用。
in oracle8i,可以使用(+)来做。