I am trying to update values in a table from another table. The table to be updated has a column containing a value that matches a system_id value on the other table. I effectively want to match the system_id and update a different column with the result.
So
Table 1 has a column A which is null, and a column B which contains the 'system_id' value
Table 2 has a column A containing the 'system_id' value and a column B containing a value that I want to add to column A on table 1.
Clear as mud, but any help would be greatly appreciated!
Never been any good at putting things into words :)
To expand...
I am using SQL Server 2005
The first table is called PEOPLE and contains a system_id and a user_id.
The second table, a temporary holding table called AJSTMP has a blank user_id column and a column containg the system_id, plus a whole host of other columns.
I need to get the user_id into the AJSTMP table in one swoop hopefully - there are approx 8,000 records to update.
SQL Update Help
Posted - 08/18/2010 : 11:04:02
