You're missing the ON portion of your query.

SELECT name FROM users INNER JOIN statuses ON users.id = statuses.user_id  statuses.geocode IS NOT NULL;