Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Normalized: requires JOIN for every order query SELECT o.id, c.name, c.email FROM orders o JOIN customers c ON c.id = o.customer_id; -- Denormalized: customer_name stored on orders (faster reads, harder to update) SELECT id, customer_name, customer_email FROM orders;
Result
Open