title: Error Code: 1248. Every derived table must have its own alias No solution found for query
body: <p>I am getting an error while using this query in MySQL. </p>
  
  <p>The query logic is correct and I have tried it in Oracle and it's running fine, but I'm getting an error when running this in MySQL. </p>
  
  <p>I looked at previous questions on StackOverflow, but didn't find something to help me.</p>
  
  <p>Here is the query:</p>
  
  <pre><code>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;
  </code></pre>
  
  <p>And here is the error:</p>
  
  <pre><code>Error Code: 1248. Every derived table must have its own alias 
  No soultion found for query
  </code></pre>