MySQL answer.
Re: List all customers from table customers that haven't made any order during year 2005?
[sql]SELECT c.firstname, c.lastname, c.address FROM customers c
WHERE c.id NOT IN (SELECT o.customer_id FROM orders o WHERE year(o.order_date) = 2005)[/sql]
|