Use and Order Advanced Condition Operators
Each SQL generated on Oracle Argus Mart contains EFFECIVE_START_DATE for supporting point-in-time querying.
The following is the syntax of PL/SQL generated on Oracle Argus Mart:
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 details, refer to Use Advanced Conditions to Create Queries on Insight Mart > Use and Order Advanced Condition Operators.
Parent topic: Create a New Advanced Condition