api: "YAML JSON TOON Database"
version: "1.0.0"
format: "json"
dataset:
  slug: "sql-join-types"
  title: "SQL Join Types"
  description: "Reference for all SQL JOIN types and their use cases."
  category: "Database Types"
  category_slug: "database-types"
  tags: "database,sql,joins,reference"
  view_count: 0
data:
  - type: "INNER JOIN"
    description: "Returns rows where there is a match in both tables."
    syntax: "SELECT * FROM a INNER JOIN b ON a.id = b.a_id"
  - type: "LEFT JOIN"
    description: "Returns all rows from the left table and matched rows from the right."
    syntax: "SELECT * FROM a LEFT JOIN b ON a.id = b.a_id"
  - type: "RIGHT JOIN"
    description: "Returns all rows from the right table and matched rows from the left."
    syntax: "SELECT * FROM a RIGHT JOIN b ON a.id = b.a_id"
  - type: "FULL OUTER JOIN"
    description: "Returns all rows from both tables, with NULLs for non-matches."
    syntax: "SELECT * FROM a FULL OUTER JOIN b ON a.id = b.a_id"
  - type: "CROSS JOIN"
    description: "Returns the Cartesian product of both tables."
    syntax: "SELECT * FROM a CROSS JOIN b"
  - type: "SELF JOIN"
    description: "A table joined with itself. Useful for hierarchical data."
    syntax: "SELECT * FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.id"