title: Merging in powerquery
body: <p>although i selected Full Join, i couldn't get the all rows from both tables. </p>
  
  <p>how can i get all rows from both tables ? (all 12093 rows)</p>
  
  <p>maybe another join type may help ? </p>
  
  <pre><code>let
      Source = Table.NestedJoin(#"Beton Irsaliye Kumulatif",{"Proje No &amp; Adi", "Firma Kodu"},#"Beton Muhasebe Kumulatif",{"Proje No &amp; Adi", "Hesap No"},"Beton Muhasebe Kumulatif",JoinKind.FullOuter)
  in
      Source
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Fx3WM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fx3WM.png" alt="enter image description here"></a></p>