Where NOT EXISTS Query
Summary
Is it possible to perform the equivalent of a Correlated sub-query using RESTContent
Is it possible to write a query like this in VBCS?
SELECT *
FROM TABLE_1 t1
WHERE NOT EXISTS (
SELECT NULL FROM TABLE_2 t2
WHERE t1.p_id = t2.p_id
AND t1.create_date < add_months(trunc(sysdate) - 18))
Version
Version: 18.3.3
Tagged:
0