sql语句,未正常结束?
Select   a.EXCEPTION_DESC,b.EXCEPTION_CAUSE,b.EXCEPTION_TIME   from   Exception_Desc   as   a   ,   Exception_INFO   as   b   where   b.EXCEPTION_TIME   between   (to_date( '2000-01-02   00:00:00 ', 'YYYY-MM-DD   HH24:MI:SS '),to_date( '2007-01-01   00:00:00 ', 'YYYY-MM-DD   HH24:MI:SS '))   and   a.EXCEPTION_CODE   =   b.EXCEPTION_CODE  
两表联查,不是很要求效率,但是现在有语法错误,第一行说语句未正常结束,请问大家是怎么回事呢?谢谢了...很急...

------解决方案--------------------
Select a.EXCEPTION_DESC,b.EXCEPTION_CAUSE,b.EXCEPTION_TIME from Exception_Desc as a , Exception_INFO as b where b.EXCEPTION_TIME between to_date( '2000-01-02 00:00:00 ', 'YYYY-MM-DD HH24:MI:SS ' and to_date( '2007-01-01 00:00:00 ', 'YYYY-MM-DD HH24:MI:SS ') and a.EXCEPTION_CODE = b.EXCEPTION_CODE


...between ...and...

------解决方案--------------------
from Exception_Desc as a , Exception_INFO as b
=〉
from Exception_Desc a , Exception_INFO b