Running a multi-table JOIN query returns unexpected duplicate rows.
SELECT * FROM orders o
JOIN customers c ON o.customer_id = c.id
JOIN products p ON o.product_id = p.id
The query above returns duplicate entries. Each row appears multiple times when joining three or more tables.
Expected: Each matching row should appear exactly once.
Actual: Rows are duplicated in the output.
This seems related to how nested JOINs are processed internally.
Running a multi-table JOIN query returns unexpected duplicate rows.
The query above returns duplicate entries. Each row appears multiple times when joining three or more tables.
Expected: Each matching row should appear exactly once.
Actual: Rows are duplicated in the output.
This seems related to how nested JOINs are processed internally.