title: How to combine two query which is derive from database
body: <p>i have two queries</p>
  
  <pre><code>$sql1="SELECT MDN, AVG(RSRP),count(case when RSRP !=0 THEN RSRP END) as total from CPE where (month(LAST_UPDATED_TIME)=1) group by MDN";
  $sql2="SELECT MDN, AVG(RSRP),count(case when RSRP !=0 THEN RSRP END) as total from CPE where (month(LAST_UPDATED_TIME)=2) group by MDN";
  </code></pre>
  
  <p>my question is how to combine these two queries in one table with 6 columns</p>
  
  <p>I tried this code but it gives error</p>
  
  <pre><code>select
  (SELECT MDN, AVG(RSRP),count(case when RSRP !=0 THEN RSRP END) as total from CPE where (month(LAST_UPDATED_TIME)=1) group by MDN) as 1,
  (SELECT MDN, AVG(RSRP),count(case when RSRP !=0 THEN RSRP END) as total from CPE where (month(LAST_UPDATED_TIME)=2) group by MDN) as 2
  </code></pre>
  
  <p>please help me to resolve this problem..</p>