title: a way to merg two mysql query into one query
body: <p>is there a way to merge these two mysql command just to get one mysql command?</p>
  
  <p>here is my first sql</p>
  
  <pre><code>select cnt1, cnt2
  
  from (select sum(cnt) as cnt1           
    from xx_dept_hardware_cnt_v  
   ) h cross join
   (select sum(cnt) as cnt2           
    from xx_dept_emp_cnt_v          
    where org_cb_id in (select cb_id from xx_dept_hardware_cnt_v) 
   ) d  
  </code></pre>
  
  <p>results</p>
  
  <pre><code>cnt1     cnt2
  -----    ----
  67       62
  </code></pre>
  
  <p>second mysql command</p>
  
  <pre><code>select     s.name software_name,
            count(s.name) install_qty
  
  from  (select name,version,hardware_id 
     from softwares 
     group by name,version,hardware_id) s ,
     dico_soft ds
  
  where  s.name = ds.extracted 
          and ds.formatted ='OS'
  group by s.name
  </code></pre>
  
  <p>result is</p>
  
  <pre><code>software_name          install_qty
  ------------           -------------
  Microsoft Window 7      1
  Microsoft Window 8      42
  Microsoft Window 8.1    2
  </code></pre>
  
  <p>and I'm trying to get </p>
  
  <pre><code>software_name           cnt1   cnt2       install_qty
  ------------            -----  -----      -------------
  Microsoft Window 7      67     62          1
  Microsoft Window 8      67     62          42
  Microsoft Window 8.1    67     62          2
  </code></pre>