title: Join on multiple columns in KQL (Azure)
body: <p>How do i create a join query that uses two or more columns?</p>
  <p>Im trying to do something like this but I cant find any examples on how to join on multiple columns</p>
  <pre><code>let logMaster = Table1 
  let logClient = Table1 
  logMaster
  | join kind=innerunique (logClient) on ($left.field1 == $right.field1 &amp;&amp; $left.field2 == $right.field2) 
  </code></pre>
  <p>Ive tried comma separated (which I think the documents kind of hint at, and <code>&amp;&amp;</code>, and <code>AND</code>, but none of them seem to work.</p>