出現(xiàn)這個(gè)報(bào)錯(cuò)的原因多半出現(xiàn)了子查詢形式的情況,比如
select * from (
select * from table where name = 'zhangsan'
)
重點(diǎn)在于自查詢要給一個(gè)臨時(shí)命名兰伤,不然就會(huì)出現(xiàn)
cannot recognize input near in joinSource
解決:給個(gè)臨時(shí)表名就好了
select * from (
select * from table where name = 'zhangsan'
)tmp
注:名字隨意蜗帜,不一定叫tmp