# Test JSON SQL Join

> Tests join primitive (INNER JOIN)

- Skill: `bdambrosio/test-json-sql-join` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add bdambrosio/test-json-sql-join`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bdambrosio/test-json-sql-join/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: bdambrosio (https://skillmd.com/u/bdambrosio)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/bdambrosio/test-json-sql-join

---


# Test Join Primitive

**Self-contained:** Creates test data internally

**Input:** 
- Creates $papers: A, B, C, D
- Creates $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