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