Advanced Condition Example

Suppose you want to create an advanced condition as follows:

WHERE Country = "Australia" AND Co-Drug Code w Study = "LAS + TAB" OR Co-Drug Code w Study = "LAS+" AND Overdose = "Yes" AND Interaction? = "Yes"

AND

You want to INTERSECT the results of this advanced condition with the existing advanced condition:

WHERE Country = "United States" OR Country = "Australia"

Table 5-2 lists the values that you enter to create the advanced condition specified in the previous example.

Table 5-2 Values Entered for the Advanced Condition Example

(	Attributes	Condition	Value	)	Operator
(	Country	equal to	AUSTRALIA	--	AND
(	Co-Drug Code w Study	equal to	LAS + TAB	--	OR
--	Co-Drug Code w Study	equal to	LAS+	)	AND
--	Overdose	equal to	Yes	--	AND
--	Interaction?	equal to	Yes	)	INTERSECT
--	COI USA OR AUSTRALIA	--	(Advanced Condition)	--	--

You do not need to include the parentheses if the PL/SQL syntax, the order and precedence of operators are correct.