在MySQL中使用这个查询时,我遇到了一个错误。
查询逻辑是正确的,我已经尝试在Oracle中运行它并且可以正常运行,但是在MySQL中运行时出现了错误。
我查看了StackOverflow上的之前的问题,但没有找到能够帮助我的内容。
这是查询:
select * from
(select PM.ID, PM.Name, PM.TIMEOUT, PMS.PROCESS_MONITOR_ID, PMS.PROCESS_START_DATE
from RATOR_IMP.PROCESS_MONITOR as PM
JOIN RATOR_IMP.PROCESS_MONITOR_STATISTIC as PMS
ON PM.ID = PMS.PROCESS_MONITOR_ID
WHERE PM.ENABLED=1 and (PM.NAME='SDRRATINGENGINE11' or PM.NAME='WORKFLOWENGINE1')
order by PMS.PROCESS_START_DATE desc)
limit 10000;
这里是错误信息:
Error Code: 1248. Every derived table must have its own alias
No soultion found for query