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
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.
Learn more at MySQL on Amazon RDSSisense is a business analytics software company. Its business intelligence product enables non-technical users to join and analyze large data sets from multiple sources, and a front-end for creating visualizations, like dashboards and reports.
Learn more at SisenseWaste 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.