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

compare table

76425c46-a19e-4509-b28d-b5c0fbb0b433 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points