5 Replies Latest reply: Jun 25, 2014 10:11 AM by Márcio Rodrigo Campestrini RSS

    Find the different fields between two tables

      Good morning and good Monday everyone!


      I need to find the differences (the different fields) between two tables.
      For example:

       

      Table A:

       

      A1     Bzw998

      A2     Cdw955

      A3     Yxp900

      A5     Djj244

      A7     Mnw104

      A8     Vbc456

      A9     Rtk777

       

      Table B:

       

      A1     Bzw998

      A2     Cdw955

      A4     Ghk888

      A5     Djj244

      A6     Ell777

      A7     Mnw104

      A8     Vbc456

       

      Table result:

       

      A3     Yxp900

      A4     Ghk888

      A6     Ell777

      A9     Rtk777

       

      How can I do this?
      Maybe with OUTER JOIN?

       

      Thanks in advance!