Join acting like Union

[speddakama]

All,

  I have a basic join which has 2 records on left + 2 on right. The output is coming to 4 records instead of expected 2 records. My other joins in the workflow are working fine.

[mborriero · Accepted solution]

The reason is because you have two rows with all the same value.

Baan_package

A

A

Packages

A

A

Therefore it connects any A in Baan_package with any A in Packages.

You should add to the join other fields. The join should be a primary key, that can identify a unique row.

[speddakama]

Thank you..you are correct.