2 Replies Latest reply: Oct 10, 2011 4:57 PM by Pooja Nanda RSS

    Exclude common data from a Table

      Hi Guys,

       

      I have two tables A and B..I need to report on data i.e.A-B(the values which is only in A not common with B).How I can do this in the script?

       

      Table A

      IDNameVal
      1XXX11
      2PQR12
      3RST13
      4FFF14
      5GGG16


      TableB

      IDNameVal
      1XXX40
      2PQR50
      6TTT60
      7SSS70
      8UUU80

       

      Final Table should be (A-B)

       

      IDNameValue
      3RST13
      4FFF14
      5GGG16

       

      Thanks....