Display Common Records?

    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.