It worked great!

Thanks for the replies.

I was wondering if its possible to list only customers who made purchases in both years.

I mean i get a lot of these:

Customers | 2014...

Thanks for the info.

Is there a way to do something like this (without the year limitation in the WHERE clause):

SELECT customers.name,

(

SELECT (SUM(unitprice*qt) AS total

FROM Products

INNER JOIN Orders ON Orders.id...