The merge-join performs inner-join of two tables, and the merge-left-join performs left join of two tables. The limitation includes:
- The left table should not contain duplicated keys.
- Both input tables should be sorted.
See Internals of Merge-Join and Merge-Left-Join.