select-這個查詢本來是oracle的，現在用mysql查詢報錯

這個查詢本來是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
求大神說下，別名加在哪

最佳回答：

就加載最後面就行了。。 你仔細看看()的位置嘛