select count(*)
from (select t.mechno,count(*)
from
(select * from boc_payinfo
where 1=1 and mechDate >= '20161001'
and mechDate <= '20161221'
and PROCSTATE = '04' and ACCCHECKSTATE = '02')
t, mp_merinfo m where t.mechno = m.mechno group by t.mechno)
[Err] 1248 - Every derived table must have its own alias
求大神说下,别名加在哪

这个查询本来是oracle的,现在用mysql查询报错
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-
2条回答 默认 最新
- miaoch 2016-12-22 02:57关注
就加载最后面就行了。。 你仔细看看()的位置嘛
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报