Display Common Records?

Wed, 07 May 2014 19:14:06 GMT

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.

Re: Display Common Records?

maxgro — Wed, 07 May 2014 19:52:31 GMT

may be in the attachment