I used to use where based joins all the time in my previous ETL tool. The only way I’ve been able to figure out how to do a where based join is to do a direct SQL statement. Is that the case or am I missing something? Are there plans to develop a where based join in the GUI?
Example:
So the sql statement for a where based join would look like:
Select *
From firstTable a
Join SecondTable b on a.id = b.id
Where a.firstRecord > b.firstRecord
It would be an extension of what we join on. I.e. a.id = b.id AND
