各位大哥帮我看看这句SQL语句到底哪里出错好不好!
在SQL*Plus中执行时,总是出现未预期的SQL命令结尾!
select Client_Info.*,NetBar_Info.NetBarName from Client_Info,NetBar_Info where Times Between to_date('2004-04-25 10:05:15','YYYY-MM-DD HH24:MI:SS') And to_date('2004-05-08 10:05:15','YYYY-MM-DD HH24:MI:SS') And Client_Info.Area_ID = 1 And Client_Info.Netbarid like '%55555%' And Client_Info.Type = 11 And Client_Info.CERT_Number like '%44444%' And NetBar_Info.Netbarname like '%22222%' And Client_Info.ClientId = '66666' And Client_Info.name like '%33333%' And Client_Info.machinename = '11111' And Client_Info.NetBarID=NetBar_Info.NetBarID order by times
我把它压缩到这一句时
select Client_Info.*,NetBar_Info.NetBarName from Client_Info,NetBar_Info where Client_Info.Times Between to_date('2004-04-25 10:05:15','YYYY-MM-DD HH24:MI:SS') And to_date('2004-05-08 10:05:15','YYYY-MM-DD HH24:MI:SS') And Client_Info.Area_ID = 1 And Client_Info.Netbarid like '%55555%'
它就说“无效的关系运算符”