Set Operations
The set used after the "From" operator can be built from a combination of saved sets.
You can use brackets. The rules of distribution and precedence are as follows:
• (A or B) or C = A or (B or C) = A or B or C
• (A and B) and C = A and (B and C) = A and B and C
• (A or (B and C) = A or B and C = (A or B) and (A or C)
• (A and (B or C) = A and B or A and C = (A and B) or (A and C)
• not (A or B) = (not A) and (not B) = not A and not B
• not (A and B) = (not A) or (not B) = not A or not B
Example:
select Org-Unit from @MainOrg-Units and not @QualityOrg-Units