没头脑QAQ 2016-12-22 02:54 采纳率: 66.7%
浏览 951
已采纳

这个查询本来是oracle的,现在用mysql查询报错

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
求大神说下,别名加在哪

  • 写回答

2条回答 默认 最新

  • miaoch 2016-12-22 02:57
    关注

    就加载最后面就行了。。 你仔细看看()的位置嘛

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?