Copy
            
            SELECT c.customerName, o.orderNumber, o.orderDate, o.requiredDate, o.shippedDate, o.status, o.comments 
FROM customers c 
JOIN orders o ON c.customerNumber = o.customerNumber;