select A.IDCARD,A.OPTIME,A.CARDFACEDATA,A.FACEDATA,A.WATCHEDID,B.NETBARIP,B.WATCHID,B.SCORE,B.FACEDATA FROM WATCHLIST AS A inner join PARARESULT AS B on A.WATCHEDID=B.WATCHID
在oracle里执行怎么报 命令未正确结束的错误啊?请大狭指教下啊?多谢~~
在oracle里执行怎么报 命令未正确结束的错误啊?请大狭指教下啊?多谢~~
A.WATCHEDID,B.NETBARIP,
B.WATCHID,B.SCORE,B.FACEDATA as BFACEDATA
FROM WATCHLIST AS A inner join PARARESULT AS B on (A.WATCHEDID=B.WATCHID) 看看
A.WATCHEDID,B.NETBARIP,B.WATCHID,B.SCORE,B.FACEDATA as BFACEDATA
FROM WATCHLIST A inner join PARARESULT B on (A.WATCHEDID=B.WATCHID)
解释下,表名取别名不能使用AS关键字,去掉就可以了。
select A.IDCARD,A.OPTIME,A.CARDFACEDATA,A.FACEDATA as AFACEDATA,
A.WATCHEDID,B.NETBARIP,B.WATCHID,B.SCORE,B.FACEDATA as BFACEDATA
FROM WATCHLIST A inner join PARARESULT B on (A.WATCHEDID=B.WATCHID)