7 Replies Latest reply: Aug 9, 2016 4:37 AM by Jyoti Ranjan RSS

    How to Extract Mismatch rows between two fields of  two Tables

    Jyoti Ranjan

      Hi,

      i have an issue.please help me.

      Table1:

      ------------

      CardNo      TxnAmount      Date

      4432xx45    300              26/07/2016

      4432xx45    250              26/07/2016

      4432xx45    300              26/07/2016

      4431xx51     10              26/07/2016

      4431xx51     20              25/07/2016

      4432xx45    300             28/07/2016

       

       

      Table2:

      -----------------

      Acno         Amount        Date

      1069          300           26/07/2016

      1069          200           26/07/2016

      1169          300           26/07/2016

      1239           10           26/07/2016

      1239           15           25/07/2016

      1345          300           28/07/2016 

       

       

      Output Table

      ----------------

      Date         MismatchAmount       Cardno       Acno

      26/07/2016      250                  4432xx45     1069

      25/07/2016      15                        --             1239

      25/07/2016      20                    4431xx51       ----

       

      Please guide me to get the output table.