Requête sur les dates :
SELECT *
FROM CO.CUSTOMERS
INNER JOIN CO.ORDERS ON CUSTOMERS.CUSTOMER_ID = ORDERS.CUSTOMER_ID
WHERE (ORDER_STATUS = ‘COMPLETE’ OR ORDER_STATUS = ‘REFUNDED’)
AND ORDER_DATETIME >= ‘2013-09-13’
Requête sur les dates :
SELECT *
FROM CO.CUSTOMERS
INNER JOIN CO.ORDERS ON CUSTOMERS.CUSTOMER_ID = ORDERS.CUSTOMER_ID
WHERE (ORDER_STATUS = ‘COMPLETE’ OR ORDER_STATUS = ‘REFUNDED’)
AND ORDER_DATETIME >= ‘2013-09-13’