sql话语,未正常结束
日期：2014-05-17 浏览次数：20787 次
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
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
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
