是执行有temp语句时提示的错误

select rowNUM, temp.* from (select * from dzjc.dzjc_flow )




是因为没有给子查询语句别名,加上别名即可



select rowNUM, temp.* from (select * from dzjc.dzjc_flow ) temp




黑色头发:http://heisetoufa.iteye.com/