title: how to do "with CTE" in mySQL?
body: <p>I have a table "posts" in MYSQL for some QA forum (for eg. stackoverflow), with the following sample data.</p>
  
  <pre><code>    INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(1,'Q',NULL,'sometext');
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(2,'Q',NULL,'randomtext');
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(3,'A',1,NULL);
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(4,'A',1,NULL);
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(5,'Q',NULL,'titletext');
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(6,'A',1,NULL);
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(7,'A',2,NULL);
      INSERT INTO POSTS (postID, type, parentID, QuesTitle) VALUES(8,'A',2,NULL);
  </code></pre>
  
  <p>postID is primary key and parentID refers to postID. A "Q" (question) type post can have multiple "A" (answers) posts(shown by their parentID). Only "Q" posts have titles but "A" posts have no titles(NULL)</p>
  
  <p>I want to <strong>select</strong> the "A" type posts along with their post ID, their parent ID and the Questitle it refers to. For example- required result is- </p>
  
  <pre><code>    postID    parentID    QuesTitle
      3         1           sometext
      4         1           sometext
      6         1           sometext
      7         2           randomtext
      8         2           randomtext
  </code></pre>
  
  <p>It would be easier using 'with' clause CTE but MYSQL doesn't support it. Can someone help me in achieving it in MYSQL?</p>