Need help with the correct syntax to use a named subquery into another query.
WHERE creation_date >= ADD_MONTHS(TRUNC(SYSDATE, 'YY'), -24)
and STATE = 'IL' ;
--INNER JOIN A.VENDOR_ID as
WHERE (A.VENDOR_NAME like '%DEPARTMENT%'
or A.VENDOR_NAME like '%ILLINOIS%');
what am I missing to call VSI as the datasource for 2nd query?