9 Replies Latest reply: Oct 8, 2016 11:58 PM by jagan mohan rao appala RSS

    How to use where not exists.

    Jim Chan

      Hi guys,

       

      I have 2 years(2015 and 2016) data. i need to check which wan is a new IDs created in years 2016 compare to 2015.

       

      so i load in 2015 data 1st.

       

      then continue to 2016 data, and add with

      where not exists(my_id); ?

       

      Rgds,

       

      Jim