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
DoubleClick for Publishers, run by Google for advertising management, is a complete revenue software service across screens, formats and sales channels. It can be used as an ad server but it also provides a variety of features for managing the sales process of online ads using a publisher's dedicated sales team.
Learn more at Doubleclick For PublishersPeriscope 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 - WarehouseWaste 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.