 <p>You either want to use <code>union all</code> or <code>cross join</code>. Use <code>union all</code> to get the results in two rows. Use <code>cross join</code> to get the results in two columns on the same row.</p> <p>Here is an example for the <code>cross join</code>:</p> <pre><code>select sumcep, sumcepout from (SELECT SUM(tutar) as sumcep FROM cepbank WHERE tarih &gt;= DATE(NOW()) ) t cross join (SELECT SUM(tutar) as sumcepout FROM cepbank_out WHERE tarih &gt;= DATE(NOW()) ) t2 </code></pre>