Two tables: Users, UserStatus
Users fields: UserID, Username,Deleted (bit)
UserStatus: UserID, Username,Status (active,inactive)
I need to update the "Deleted" field when a user's status is Inactive.
Set deleted = '1'
Where username IN (select username from UserStatus where status = 'inactive')
Running this query throws the "Subquery returned more than 1 value." error.
What am I missing?
Thanks for your help.