AnsweredAssumed Answered

ExecuteSQL(SELECT FROM... NOT IN SELECT FROM)  is this possible?

Question asked by JeffMillard on Jul 24, 2013
Latest reply on Jul 25, 2013 by philmodjunk

Title

ExecuteSQL(SELECT FROM... NOT IN SELECT FROM)  is this possible?

Post

     Okay, one of the coolest 'real' SQL capabilities is to select a list of values either in or not in another select list:  Something like "SELECT EMPIDS FROM ALL_EMPLOYEES NOT IN (SELECT EMPIDS FROM TERMINATED_EMPLOYEES)"
     -- This would return a only the EMPIDS from the ALL_EMPLOYEES table that did not exist in the TERMINATED_EMPLOYEES table.

     Cant seem to do this in ExecuteSQL() statement...any suggestions for formatting?

     Jeff

Outcomes