4 Replies Latest reply: Feb 10, 2011 10:45 AM by the fourth RSS

    how to see unmatched records

      i want those records who are not match each other

      match records (itemid) = 1,3,4

      unmatch records(itemid) = 2,5,6,79

      i want to see these records(2,5,6,7,9) in

       

       



       

      Table 1
      table1_idtable1_itemidtable1_name/desc
      11fksdf
      21fksdf
      32fksdf
      42fksdf
      53fksdf
      64fksdf
      75fksdf
      Table 2
      table2_idtable2_itemidtable2_name/desc
      11fksdf
      26fksdf
      31fksdf
      44fksdf
      57fksdf
      63fksdf
      79fksdf


       

       

      or

      is it possible to make "unmatch" and "match" fields

      ciriteria

      Both
      Match

      Unmatch

      when i clik both it show all records(1,2,3,4,5,6,7,9)

      when i click on Match records it will show only those records whose item id are in both table(,1,2,4)

      when i click on unmatch then it will show only those records whose itme id are not match in both tables i.e(2,5,6,7,9)