3 Replies Latest reply on Nov 8, 2011 5:33 PM by EZGms

    Retrieve data using not in clause

    EZGms
      Hi,

      Ihave two temporal tables(temp,temp2) with two columns on each
      temp(phone,operator)
      temp2(phone,operator)
      the phone and operator columns are unique key in temp2

      what can i do to retrieve the data which are in temp but not in temp2?

      thanks in advanced