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
Magento is an ecommerce platform which provides online merchants with a flexible shopping cart system, and customization of their online store. It offers marketing, search engine optimization, and catalog-management tools.Learn more at Magento via MySQL
Periscope Data is the analytics system of record for professional data teams. They also offer a managed warehouse service making it easier for analysts to launch a secure data warehouse.Learn more at Periscope Data - Warehouse
Waste 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.