title: Cypher join informations from different tables into a single one
body: <p>I'm new in cypher and I'm struggling with this problem:</p>
  <p>I have these two queries</p>
  <pre><code>MATCH (u:UserNode)-[:PROMOTER_OF*1..]-&gt;(c:UserNode)
  WHERE u.promoterActualRole IN [&quot;GOLD&quot;,&quot;RUBY&quot;,&quot;SAPPHIRE&quot;,&quot;BRONZE&quot;,&quot;EMERALD&quot;, &quot;DIAMOND&quot;]
      AND datetime(c.promoterStartActivity) &gt;= datetime(&quot;2021-02-01T00:00:00Z&quot;) 
      AND datetime(c.promoterStartActivity)&lt;= datetime(&quot;2021-05-31T23:59:59Z&quot;)
      AND c.promoterEnabled = true
      AND u.firstName=&quot;Gianvito&quot;
  WITH distinct u as user, count(c) as num_promoter
  WHERE num_promoter &gt;= 150
  RETURN user.firstName as name, user.email as email, num_promoter
  </code></pre>
  <p>which will return me a table like this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>email</th>
  <th>num_promoter</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Gianvito</td>
  <td>gianvito@email.com</td>
  <td>1475</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>and</p>
  <pre><code>MATCH (u:UserNode)-[:PROMOTER_OF*1..]-&gt;(c:UserNode)
  WHERE u.promoterActualRole IN [&quot;GOLD&quot;,&quot;RUBY&quot;,&quot;SAPPHIRE&quot;,&quot;BRONZE&quot;,&quot;EMERALD&quot;, &quot;DIAMOND&quot;]
      AND datetime(c.subscriptionDate) &gt;= datetime(&quot;2021-02-01T00:00:00Z&quot;) 
      AND datetime(c.subscriptionDate)&lt;= datetime(&quot;2021-05-31T23:59:59Z&quot;)
      AND c.kycStatus = &quot;OK&quot;
      AND u.firstName=&quot;Gianvito&quot;
  WITH distinct u as user, count(c) as num_swaggy
  WHERE num_swaggy &gt;= 1
  RETURN user.firstName as name, user.email as email , num_swaggy
  </code></pre>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>email</th>
  <th>num_swaggy</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Gianvito</td>
  <td>gianvito@email.com</td>
  <td>1820</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I would like to merge these two results into a single table.
  I was doing a Union but in this way I can only create a single table with two different rows with duplicate common information and &quot;null&quot; as non present value.
  How can I do if I want to obtain a table like this one?</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>email</th>
  <th>num_promoter</th>
  <th>num_swaggy</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Gianvito</td>
  <td>gianvito@email.com</td>
  <td>1475</td>
  <td>1820</td>
  </tr>
  </tbody>
  </table>
  </div>