title: Combine Multiple Query Results in MySQL (by column)
body: <p>I have 4 different queries and each of them return individual unique set of Results.
  I need to combine the Query Results with using a single query.</p>
  
  <p>my sample queries are:</p>
  
  <pre><code>1. select cls.* from (calls as cls inner join calls_users as clsusr on cls.id=clsusr.call_id) inner join users as usr on usr.id=cls.assigned_user_id where cls.assigned_user_id='seed_max_id'
  
  2. select mtn.* from (meetings as mtn inner join meetings_users as mtnusr on mtn.id=mtnusr.meeting_id) inner join users as usr on usr.id=mtn.assigned_user_id where mtn.assigned_user_id='seed_max_id'
  
  3. select tsk.* from tasks as tsk inner join users as usr on usr.id=tsk.assigned_user_id where tsk.assigned_user_id='seed_max_id'
  
  4. select nts.* from (notes as nts inner join accounts as acnts on acnts.id=nts.parent_id) inner join users as usr on usr.id=acnts.assigned_user_id where acnts.assigned_user_id='seed_max_id'
  </code></pre>
  
  <p>I tried the following way, but it didn't work</p>
  
  <pre><code>Combine: SELECT tbl1.*, tbl2.* 
  from (select cls.* from (calls as cls inner join calls_users as clsusr on cls.id=clsusr.call_id) inner join users as usr on usr.id=cls.assigned_user_id where cls.assigned_user_id='seed_max_id') as tbl1 
  left  outer join
  (select mtn.* from (meetings as mtn inner join meetings_users as mtnusr on mtn.id=mtnusr.meeting_id) inner join users as usr on usr.id=mtn.assigned_user_id where mtn.assigned_user_id='seed_max_id') as tbl2
  using(assigned_user_id)
  </code></pre>
  
  <p>i also tried right outer join and other inner joins
  I am really stuck, if any one know the solution then please help.
  I need the similar result like <a href="https://stackoverflow.com/questions/1792850/mysql-join-two-tables-with-different-number-of-rows-and-one-same-column-name">How can I join two tables with different number of rows in MySQL?</a>.</p>
  
  <p>Data Sample:</p>
  
  <p>From Query 1:</p>
  
  <pre><code>+-------------------------------------------+------------------+-
  | Call Name                                 | Call Description |
  +-------------------------------------------+------------------+-
  | Discuss Review Process                    | NULL             |
  | Get More information on the proposed deal | NULL             |
  | Left a message                            | NULL             |
  | Discuss Review Process                    | NULL             |
  +-------------------------------------------+------------------+
  </code></pre>
  
  <p>From Query 2: </p>
  
  <pre><code>+-----------------------+-----------------------------------------------------------
  | Meeting Name          | Meeting Description
  +-----------------------+-----------------------------------------------------------
  | Review needs          | Meeting to discuss project plan and hash out the details o
  | Initial discussion    | Meeting to discuss project plan and hash out the details o
  | Demo                  | Meeting to discuss project plan and hash out the details o
  | Discuss pricing       | Meeting to discuss project plan and hash out the details o
  | Review needs          | Meeting to discuss project plan and hash out the details o
  +-----------------------+-----------------------------------------------------------
  </code></pre>
  
  <p>i need to combine the columns like the following:</p>
  
  <pre><code>+-------------------------------------------+------------------+-------------------+-------------------+
  | Call Name                                 | Call Description |Meeting Name       |Meeting Description|
  +-------------------------------------------+------------------+-------------------+-------------------+
  | Discuss Review Process                    | NULL             |Review needs       |Meeting to discuss |
  | Get More information on the proposed deal | NULL             |Initial discussion |Meeting to discuss |
  | Left a message                            | NULL             |Demo               |Meeting to discuss |
  | NULL                                   | NULL             |Discuss pricing    |Meeting to discuss |
  | NULL                                      | NULL             |Review needs       |Meeting to discuss |
  +-------------------------------------------+------------------+-------------------+-------------------+
  </code></pre>