Use and Order Advanced Condition Operators

Use the following order of precedence for the operators you can select when creating an advanced condition.

Order	Operator	Use
1	AND	Use with all fields available in an advanced condition.
2	OR	Use with all fields available in an advanced condition.
3	INTERSECT	Use between queries (AC Library Attributes)
4	MINUS	Use between queries (AC Library Attributes)
5	UNION	Use between queries (AC Library Attributes)

Using an INTERSECT, MINUS, or UNION operator results in the creation of two separate select clauses. Therefore, use these operators between different queries.

Be sure to use correct PL/SQL syntax:

SELECT
table1.common_column
FROM
Table1, table2, table3
WHERE 
Table1.column2 = table2.column2
AND 
Table2.column3 = table3.column3 
INTERSECT 
SELECT 
Table4.common_column
FROM
Table4, table5, table6
WHERE
Table4.column2 = table5.column2
AND
Table5.column3 = table6.column3

For more information, see:

• Advanced Condition Example
  
• Sample SQL Generated