Proper syntax for named subquery - As ABC
Need help with the correct syntax to use a named subquery into another query.
AS VSI
SELECT VENDOR_SITE_ID
FROM tblAll
WHERE creation_date >= ADD_MONTHS(TRUNC(SYSDATE, 'YY'), -24)
and STATE = 'IL' ;
SELECT *
FROM VSI
--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?
Thanks,
Karen
AS VSI
SELECT VENDOR_SITE_ID
FROM tblAll
WHERE creation_date >= ADD_MONTHS(TRUNC(SYSDATE, 'YY'), -24)
and STATE = 'IL' ;
SELECT *
FROM VSI
--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?
Thanks,
Karen
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
:) Now it makes more sense
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
WITH VSI AS
(
SELECT VENDOR_SITE_ID, STATE
FROM tblALL
WHERE STATE = 'IL'
)
SELECT S.VENDOR_NAME, A.VENDOR_SITE_ID, A.STATE
FROM tbl123 S
INNER JOIN VSI A on A.VENDOR_SITE_ID = S.VENDOR_ID;
--WHERE (S.VENDOR_NAME like '%DEPARTMENT%'
-- or S.VENDOR_NAME like '%ILLINOIS%');