test-json-sql-join git:20251125.79ed510A

Immutable. This exact content is served forever at /api/v1/blob/43c02061f06d6ac7.

---
name: test-json-sql-join
description: Tests join primitive (INNER JOIN)
manual_only: true
---

# Test Join Primitive

**Requires:** Run test-json-sql-setup first to create $papers and $authors

**Input:** 
- $papers: A, B, C, D
- $authors: A (Alice), B (Bob), E (Eve)

**Operation:** Inner join on id field

**Expected Output:** $joined collection with 2 items (A and B have matches)
- Paper A + Author Alice
- Paper B + Author Bob