06 Join

-- 06_join: Attach customer names to orders
-- Read-only reference query. Setup must be loaded first.
SELECT o.order_id,c.customer_name,o.channel
FROM aabha_sql.orders AS o JOIN aabha_sql.customers AS c
 ON c.customer_id=o.customer_id
WHERE o.order_id<=1004 ORDER BY o.order_id;