JSON 1 (Left Dataset)

JSON 2 (Right Dataset)

3
Left Dataset Items
3
Right Dataset Items
2
Merged Results

Merged Result (Inner Join)

{ "result": [ { "id": 1, "name": "John", "age": 30, "city": "New York", "email": "john@example.com", "department": "Engineering" }, { "id": 2, "name": "Jane", "age": 25, "city": "Chicago", "email": "jane@example.com", "department": "Marketing" } ] }

How It Works

Inner Join

Only objects with matching key values in both datasets are included in the result.

Key Field

The field name that exists in both datasets to use for matching (e.g., "id", "email", "name")

Result

The merged objects contain all properties from both datasets for the matching keys.