what's wrong with this mysql query?

[N!ck]

SELECT announcement.title, announcement.userid, announcement.startdate, announcement.pagetext, user2.username as username FROM announcement LEFT JOIN user AS user2 ON (user.userid = announcement.userid) ORDER BY startdate, endate LIMIT 5

I'm getting an error (#1109).

[Admin]

Change user.userid to user2.userid in the JOIN.

[N!ck]

wow. now that's service. thanks!

[Admin]

:)