1 Reply Latest reply: May 7, 2014 3:52 PM by Massimo Grossi RSS

    Display Common Records?

    john pett

      Hi All

       

      I Have 2 Table with 5 same fields,  where F1 is Id it is unique in one table,but that id was not unique in another table.

       

      Here:  In Table1 For F5 there is only one F1.

       

      In Table2 For F5 there will be more than one F1  .  Now i need

       

      The records of F1 and F5 for

       

      1.The Common Records in both the tables

      2.The Records those are not in table2 but in table1

      3.The Records those are not in table1 but in table2

       

      Please find the Attachment for data reference.

       

      Thanks For Everyone.