Same records

[sonysree88]

Hi Team,

I have 2 data sets 1 is A and another one is B

A: 1,2,3,  upto 10 millions record

B:1,2,3, ......10 millions of record.

I need to get the associated records from the both the data sets in to one resultant set.

Output:

A B

5  5

10 10

20 20

upto 10mils records

Regards,

Sunitha

[agni_gold]

I need to get the associated records from the both the data sets in to one resultant set.

What do you mean by above, can you explain bit more on this ?

[sonysree88]

I want to show the Same records from both the 2 data  sets There are no common fields but need to associate with common records

[agni_gold]

if we make it simple ,
you have 2 tables , A & B , you want another table C, in which common records from A & B should be there correct ?

[anushree1]

There are multiple ways to get it done like you may use Inner Join by renaming the field and having a condition basis the same, or probably use Exists Keyword, it depends on the kind of data you are dealing with , providing a sample input and desired output , will help to find what exactly you are looking for

[sonysree88]

Hi Anushree,

Kindly let us know all the ways to get the result.