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
两表联查,不是很要求效率,但是现在有语法错误,第一行说语句未正常结束,请问大家是怎么回事呢?谢谢了...很急...
两表联查,不是很要求效率,但是现在有语法错误,第一行说语句未正常结束,请问大家是怎么回事呢?谢谢了...很急...
...between ...and...
=〉
from Exception_Desc a , Exception_INFO b