Nested SELECT

[it99ama]

Hi!
I'm new to MySQL and want to do a nested SELECT statement.

I want to get all years stored in the database except the last year:
(content is the table and null values exists)

SELECT DISTINCT YEAR(content.date)
FROM content
WHERE(((YEAR(content.date)) IS NOT null)) AND YEAR(content.date) < (SELECT YEAR(MAX (content.date)) FROM content))
ORDER BY YEAR(content.date) DESC

What is wrong?


Is there an easier way to do this?

Regards
/Anders :-)