SQL-server -> MySQL

[Anon]

Hey,

SELECT usersrooms.room
FROM employees
INNER JOIN usersrooms
ON employees.name = usersrooms.userid
WHERE employees.id = 1

this works fine in SQL-server but MySQL gives me

MySQL said: You have an error in your SQL syntax near 'ON employees.name = usersrooms.userid WHERE (employees.id = 1)' at line 3

Any ideas/comments?

Thanks.