Hello, I need some help on the table join.
When we run a report, there's "record to include" section where I could join other tables for advanced filter.
Is the left join supported when adding table join? for example, I wanted to filter out any transactions has marked as disputed or other status from my dunning letter. but when I add the table join, only transactions with a disputed status will be shown, so I guess, by default, it's inner join, I wonder if there's a way to have left join, so all the transactions can be returned as a result, thanks!
