3 Replies Latest reply: Oct 12, 2015 4:39 AM by Petter Skjolden RSS

    Select from set A where not in Set B

    Abhishek Jain

      How can I write the following (or create a flag) as an expression in a straight table. I cannot write that in load statement.

       

      select field1, field2 from tableA field3 not in (select field3 from tableB where field4 in ('x','y','z'));