title: How do one request with 2 request SQL?
body: <p>i have some problem to do an JOIN with two SQL request</p>
  
  <p>request 1:</p>
  
  <pre><code>SELECT *
  FROM `tableA` 
  INNER JOIN tableB
  ON tableA.products_id=tableB.products_id
  LEFT JOIN tableC
  ON tableB.products_id=tableC.products_id
  LEFT JOIN tableD AS CD
  ON CD.categories_id=tableC.categories_id
  WHERE orders_id &gt;=80000 AND orders_id &lt;=80010 GROUP BY orders_id
  </code></pre>
  
  <p>Request 2:</p>
  
  <pre><code>SELECT *     
  FROM `tableA` AS OP
  LEFT JOIN tableE AS PTP
  ON OP.products_id=PTP.products_id
  
  LEFT JOIN tableD AS CD
  ON PTP.categories_id=CD.categories_id
  
  WHERE  orders_id &gt;=80000 AND orders_id &lt;=80010 GROUP BY orders_id
  </code></pre>
  
  <p><strong>it's is possible to do only ONE request with those two request ? or it's just impossible?
  thanks for any help you can give</strong></p>