title: Incompatibility between MySQL and MariaDB - Subquery in FROM clause.
body: <p>MariaDB claims to be a drop-in replacement for MySQL, but <a href="https://dev.mysql.com/doc/refman/5.7/en/create-view.html" rel="nofollow noreferrer">MySQL docs</a> states that this feature is available since version 5.7.7:</p>
  
  <blockquote>
    <p>Before MySQL 5.7.7, the SELECT statement cannot contain a subquery in
    the FROM clause.</p>
  </blockquote>
  
  <p><a href="https://mariadb.com/kb/en/mariadb/create-view/" rel="nofollow noreferrer">MariaDB knowledge base</a> says this is not allowed:</p>
  
  <blockquote>
    <p>The SELECT statement cannot contain a subquery in the FROM clause. </p>
  </blockquote>
  
  <p>However, this is not listed in <a href="https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/#incompatibilities-between-mariadb-101-and-mysql-57" rel="nofollow noreferrer">MariaDB's compatibility page</a>.</p>
  
  <p>I've made some tests and it seems like there's no support for this kind of query in MariaDB, but the conflicting information in MariaDB docs made me confused. So, which one of the pages from MariaDB is right? Is this feature really not supported (yet)?</p>