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); ?