How to keep from repeating subquery in where clause

[tibberous]

I have a query like:

 

select * from users where (select `State` from `locations` where `locations`.`id`=`users`.`id`)!='PA' or (select `State` from `locations` where `locations`.`id`=`users`.`id`)!='NJ' or (select `State` from `locations` where `locations`.`id`=`users`.`id`)!='NY' or (select `State` from `locations` where `locations`.`id`=`users`.`id`)!='TX' ... ect

 

This is obviously terrible - if only because it makes the query impossibly long to read. How can I get around this?

[Mchl]

SELECT 
  u.* 
FROM
  users AS u
INNER JOIN
  locations AS l
ON
  l.id = u.id
WHERE
  l.state NOT IN('PA','NJ','NY',...)

[tibberous]

Thanks!