# Merge join

**URL:** <https://community.automationedge.com/t/merge-join/2496>\
**Category:** Get Help & Discuss\
**Created:** [August 20, 2020, 12:16pm UTC](https://community.automationedge.com/t/merge-join/2496 "2020-08-20T12:16:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pradnyaB](https://avatars.discourse-cdn.com/v4/letter/p/b487fb/32.png) [@pradnyaB](https://community.automationedge.com/u/pradnyaB)\
**Post date:** [August 20, 2020, 12:16pm UTC](https://community.automationedge.com/t/merge-join/2496/1 "2020-08-20T12:16:28Z")

</div>

Even though there is no common field present in two excel sheets can still Merge join Plugin be used?

---

<div class="post-metadata">

**Author:** ![madhavi.bade](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@madhavi.bade](https://community.automationedge.com/u/madhavi.bade)\
**Post date:** [August 20, 2020, 12:25pm UTC](https://community.automationedge.com/t/merge-join/2496/2 "2020-08-20T12:25:52Z")

</div>

Hi Pradnya,  
Generally we specify common key fields in Merge join,  
But t yes, merge join can be used without specifying key fields to match. The result will be like the CARTESIAN JOIN or the CROSS JOIN.