4 Replies Latest reply: Apr 15, 2011 8:56 AM by Muncho Ts RSS

    Data Comparison between two tables

      Hi All,

      I have two tables A and B and I have to comapre A.Column1 with B.column1 and have to find out what are the nonmatching data in table A.Column1.Below is an example and expected result is 400 and 500. Can you please let me know what would be a best way to do so?

      A B
      ----- --------
      100 100
      200 200
      300 300
      400 800
      500 900

      Thanks,Pooja