Left Outer Join 问题 ~~
select * from B_WORKREC
Left Outer Join b_opertype on B_WORKREC.OPERTYPE = b_opertype.opertype
Left Outer Join B_OPERMETHOD on B_WORKREC.OPERMETHOD= B_OPERMETHOD.OPERMETHOD
where trunc(opertime)=to_date('2004-06-24','yyyy-mm-dd');
会出来好多数据~~ 并不是B_WORKREC表的行数