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