title: Performing Complex Join in Nifi
body: <p>I am very new to Nifi and trying to perform a SQL against SQL server which has multiple tables being joined and also selecting attributes from each one. How can we perform this in Nifi. I am seeing "Generate Table Fetch" which allows me to mention "Table Name" and its "Where Clause". Not sure, how do we perform complex join if there are multiple tables involved.</p>
  
  <p>Example-</p>
  
  <pre><code>Select 
  a.col1,
  a.col2,
  b.col3,
  b.col4,
  c.col5,
  c.col6
  from a left outer join b
  on a.colx=b.colx
  inner join c
  on a.coly = c.coly
  where exists (some condition etc)
  </code></pre>
  
  <p>Thanks,
  Siddhartha</p>