outer join with WHERE NOT EXISTS statement
I'm looking for a way to configure a report with an outer join and the WHERE NOT EXISTS statement (known from native SQL). Sadly I do not find a solution.
The report should list all incidents that
- are in status “Unresolved” in a certain queue and
- do not have an transaction of trans_type “forwarded”
So I would create a report with incidents table as root. I further would add transactions as outer join table and then ...?
Thanks in advance