Update rows in a table using a list of ID values

[matpj]

I have a table in which I need to update certain rows.

the key field in the table is Proj_ID.
another process creates a table that lists projects that need updating.

how do I write some SQL to do this.

the script needs to be something like.

UPDATE <table1>
SET <table1>.<value> = "CLI"
WHERE <table1>.Proj_ID In <table containing list of project ids>

this syntax doesn't seem to work though.

any ideas?

thanks,
Matt

 

[Crowley16]

try:

UPDATE tbl1
SET blah = 'Blah'
WHERE tbl1.ProjID IN (Select ProjID FROM tbl2);

 

[matpj]

hmm, that works.
dunno why it didn't work before. might be because I didn't put the table in square brackets (it had a space in its title)

thanks for that.

 

[Crowley16]

yes, that would probably give you a syntax error, personally I never include spaces in any names...