Need Help Update/Input Data

[BigBig5]

I have two tables that have a list of user info. One table has a status field. I want to update the status of users that is in table 1 but does not match any user in table 2 with "text". How would I do that? I do have an unmatch query of both tables.

[hapm]

Ever tried the IN operator? Its very handy in such cases.

UPDATE table_1 SET table_1.status = "text" WHERE NOT table_1.userid IN (SELECT table_2.userid FROM table_2)

[BigBig5]

Ever tried the IN operator? Its very handy in such cases.

UPDATE table_1 SET table_1.status = "text" WHERE NOT table_1.userid IN (SELECT table_2.userid FROM table_2)

Is this code you have for SQL?

[BigBig5]

Ever tried the IN operator? Its very handy in such cases.

UPDATE table_1 SET table_1.status = "text" WHERE NOT table_1.userid IN (SELECT table_2.userid FROM table_2)

I tried this code and its updating the status of the users that match, but I want it to the users that don't match.