6 Replies Latest reply on Jul 25, 2013 12:47 PM by philmodjunk

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

    JeffMillard

      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