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 |
-- |
|
( |
Co-Drug Code w Study |
equal to |
LAS + TAB |
-- |
|
-- |
Co-Drug Code w Study |
equal to |
LAS+ |
) |
|
-- |
Overdose |
equal to |
Yes |
-- |
|
-- |
Interaction? |
equal to |
Yes |
) |
|
-- |
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.
Parent topic: Use and Order Advanced Condition Operators