SQL statement help

Dell / OPTIPLEX 755
June 1, 2010 at 08:26:44
Specs: Microsoft Windows XP Professional, 2.327 GHz / 3325 MB
can someone help me with this sql code...

2 tables.
table 1 = User_master
table 2 = update_users

I need to update user_master like so...
update user_master
set status = 'I'
where user_id IN ()

problem is I have to over 10k user_id to update.
So created new table called update_users and imported all user_id's into that table.
How can I read all user_id's from that table, then update user_master status column for all
users id's found in update_users ?

See More: SQL statement help

Report •

June 1, 2010 at 14:52:44
What Columns do you want to compare or join on?

Report •

June 2, 2010 at 13:48:12
update user_master
set status = 'I'
where user_id IN (select user_id from update_users)

I would assume.

Report •

Related Solutions

Ask Question