Hacker News new | ask | show | jobs
by sandpaper26 1000 days ago
On the section about partitioned joins, how is that different from

SELECT sale_dt, name, Sum(quantity) FROM sales LEFT JOIN product ON sales.product_id = product.id GROUP BY sale_dt, name;