Multiple Join gives duplicate records

[AnandKumar1]

Hi,

I'm trying to join 2 different files based on some condition .

This is my 1st file data

Fund	Security
1A	89236THM0
2B	05253JAU5
3C	USD

This is my 2nd file data

Fund	ISIN	Cusip	BBSEC
1A	49456BAM3	89236THM0	89236THM0
2B	05253JAU5	28404Hk424	290424244
3C	USD2404JL	20880USD839	2040848

I've used 3 Join tool 

1) Fund=Fund and Security = ISIN

2) Fund= Fund and Security= Cusip

3) Fund= Fund and Security= BBSEC

Now the problem is some value in present in both of security is present in both cusip and bbsec . So same record is coming in 2 join output which is actually duplicate. Like Security= 89236THM0  is present in Cusip & BBsec of second file.

How to handle 

[AnandKumar1]

@atcodedog05 @HomesickSurfer 

I've 1300 records in left table and 900 in right table. If i join i should get <=1300 total records but instead i'm getting 117000

I dont understand why this cartesian join is happening when i've given join condition based on fund?

[HomesickSurfer]

Hi @AnandKumar1 

Why Join?