Share
ReportHi all,
I'm trying to build a 'not in' FetchXML query using a left outer join, I've been successful in creating a simple one where for example, I want to list all Accounts where all child Contacts do not have a Status of X. However, is it possible to filter based on a parent table of the Contact, e.g show me all Accounts where the parent record Y on all child Contacts does not have a Status of X? I can't seem to figure out whether it should be an inner or outer join, whether I need to be using aliases, etc. I've tried loads of variations with no luck, has anyone done this before? Thanks in advance!
Categories:
I have the same question (0)
All responses (
Answers (
294
