SELECT o.order_number,
p.product_name, i.quantity, i.unit
FROM [ order ] o
JOIN order_item i ON o.id = i.order_id
JOIN product p ON p.id = i.product_id
ORDER BY o.order_number
Stripe is a software platform for running an internet business, helping to power commerce for businesses of all sizes. Stripe provides a service for accepting and managing all of your online payments.
Learn more at StripeAmazon Redshift is a fast, fully managed, petabyte-scale data warehouse solution that makes it simple and cost-effective to efficiently analyze all of your data using your existing business intelligence tools.
Learn more at Amazon RedshiftWaste less time, spend less money, and scale anytime
With 100+ connectors and counting, we ensure the data in your warehouse is always up to date and accessible by analysts.