Display Common Records?

[#1]

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.

[maxgro]

Attachment ?

[#3]

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.

[Greg_Williams]

Will this work for your desired solution?

-Greg

[#5]

May be like attached.

Thanks

AJ

[#6]

Yes Greg.

[SunilChauhan]

use inner join for common records

and

where not exists b/w two table  for two times for not common records

[SunilChauhan]

for common

Tab1:

Load

from table 1;

inner join

load

from table 2

for record in table2 but not in one

Tab2:

Load from Table1;

Tab3:

Load from table2 where not exists(table1Id,Table2ID);

drop table Tab2;

and just opposite for records in 1 but not in table 2

hope thishelps

[Greg_Williams]

Great. Respectfully requesting > can you please mark this thread Helpful or Correct. Thanks.

[#10]

Hi Greg Sorry for late reply...

Its not use full for my scenario.