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.