3 Replies Latest reply: Feb 24, 2014 4:12 AM by AnnPricks E RSS

    compare table

    76425c46-a19e-4509-b28d-b5c0fbb0b433

      Hi ,

      Can I have a query to get the below output:

       

      I have two tables:

       

      EQPGRP_IDEQUIPMENT_IDAREARA
      MIMP-A15MIMP-A15IMPL5YY
      DNSCB-02DNSCB-02CLEAN5YY
      SCRS-A05SCRS-A05CLEAN5Y

      N

       

      EQPGRP_IDEQUIPMENT_IDAREARA
      MIMP-A15MIMP-A153ACLEANYN
      DNSCB-02DNSCB-023ACLEANYN
      SCRS-A05SCRS-A053ACLEANYN

       

       

      I need a output like below :-

       

       


        EQPT ID
      RAEQPT IDRAIs R same in Both ?Is A same in Both?
      STRP-A12YYSTRP-A12YNOKfail
      METL-515YYMETL-515NNFAILfail
      CAPO-A11YyCAPO-A11YYOKok