You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Where NOT EXISTS Query

Received Response
12
Views
4
Comments
edited Oct 31, 2018 5:55PM in Visual Builder 4 comments

Summary

Is it possible to perform the equivalent of a Correlated sub-query using REST

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!