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
Sailthru helps modern marketers at leading retail and media companies build deeper, longer-lasting relationships with their customers. Sailthru personalizes individual customer experiences across digital communication channels—in email, on a brand’s website and in their mobile applications.Learn more at Sailthru
MySQL is an open source database that can be used as your data warehouse destination. MySQL is a cost-effective choice now developed by Oracle.Learn more at MySQL 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.