I'm trying to find 2 different result via JOINS. Table look like;

SELECT id,member_id,registered_year FROM records;

I can listing which members registered in 2012 and also in 2013 with;

SELECT member_id FROM records a
INNER JOIN records b ON a.member_id=b.member_id
WHERE  a.registered_year='2013' AND b.registered_year='2012';

But I can't list revers of It. How can I list which members were registered in 2012 but not in 2013?

Thnx in advance.