Oracle - The IN clause
INSERT INTO SRM.ENTITIES_AP_CATEGORY (ENTITIESID,
AP_CATEGORY_ID,
ADDDATE,
PROJECTSID)
SELECT A.ENTITIESID,
B.AP_CATEGORY_ID,
SYSDATE,
804
FROM QXPLORE.ENTITIES A, SRM.AP_CATEGORY B
WHERE A.ENTITIESID = VARENTITIESID
AND B.AP_CATEGORY_ID IN (101, 102, 103, 104)
AND (ENTITIESID, AP_CATEGORY_ID, 804) NOT IN
(SELECT ENTITIESID, AP_CATEGORY_ID, PROJECTSID
FROM SRM.ENTITIES_AP_CATEGORY
WHERE ENTITIESID = VARENTITIESID AND PROJECTSID = 804);
page revision: 1, last edited: 03 Oct 2015 01:27