How to perform complex join if there are multiple tables involved Using Apache-nifi.
We are 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.we are seeing "Generate Table Fetch" which allows to mention "Table Name" and its "Where Clause". Not sure, how do we perform complex join if there are multiple tables involved.
Example-
Select
x.mycol1,
x.mycol2,
y.mycol3,
y.mycol4,
z.mycol5,
z.mycol6
from a left outer join y
on x.mycolx=y.mycolx
inner join z
on x.mycoly = x.mycoly
where exists (some condition etc)
Tagged: