title: MSSQL - 2 Tables with multiple rows merge in one table
body: <p>I have 2 selects which returns 2 tables, in each table I have 12 rows, and 2 column, now I want to have just one table.</p>
  
  <pre><code>---- First Table
      select f. date as Date, f.value as Month1 
          from
              (
                  select b.date as date, sum(b.value) as value
                  from business bu
                      join bus_cat buc on buc.id = bu.id
                      join cat ct on ct.id = buc.type_id
                      join bus2 b on b.id = buc.id
                  where ct.id = 1
                      and b.value &lt;&gt; 0
                      and b.date between @start and @actual
                      and bu.name = @bu_name
                  group by b.date, b.value
  
                  union all
  
                  select b5.date as date, sum(b5.value) as value
                  from bus bu
                      join bus_cat buc on buc.id = bu.id
                      join cat ct on ct.id = buc.type_id
                      join bus3 b5 on b5.id = buc.id
                  where ct.id = 1
                      and b5.value &lt;&gt; 0
                      and b5.date between @nextM and @endM
                      and bu.name = @bu_name
                  group by b5.date, b5.value
  
              ) as f
  
  
  ---- Second Table   
  
          select f1. date as Date, f1.value as Month2 
          from
              (
                  select b.date as date, sum(b.value) as value
                  from business bu
                      join bus_cat buc on buc.id = bu.id
                      join cat ct on ct.id = buc.type_id
                      join bus2 b on b.id = buc.id
                  where ct.id = 1
                      and b.value &lt;&gt; 0
                      and b.date between @start and @actual
                      and bu.name = @bu_name
                  group by b.date, b.value
  
                  union all
  
                  select b5.date as date, sum(b5.value) as value
                  from bus bu
                      join bus_cat buc on buc.id = bu.id
                      join cat ct on ct.id = buc.type_id
                      join bus3 b5 on b5.id = buc.id
                  where ct.id = 1
                      and b5.value &lt;&gt; 0
                      and b5.date between @nextM and @endM
                      and bu.name = @bu_name
                  group by b5.date, b5.value
  
              ) as f1
  </code></pre>
  
  <p>The actual output for first table is:</p>
  
  <pre><code>Date                Month1
  2015-01-01        23
  2015-01-01        77
  </code></pre>
  
  <p>and for second:</p>
  
  <pre><code>Date                Month2
  2015-01-01        88
  2015-01-01        90
  </code></pre>
  
  <p>All I want is to merge this 2 tables to look like </p>
  
  <pre><code>   Date                Month1      Date                Month2
      2015-01-01        23         2015-01-01             77          
      2015-01-01        28         2015-01-01             787
  </code></pre>