subquery question? 1

[link9]

Ok, I have two tables -- one with 1000 records and the other with 100000...

the 1000 record table (tempTable) has two columns, rk and unit -- and the rk will match back to 1000 records in the other table, called heCustRK

So, I have values in the tempTable that I want to use to update the corresponding values in the heCustRK table...

Something like this:
update heCustRK set unit = tempTable.unit where heCustRK.rk = tempTable.rk

but of course, this doesn't work. Can anyone help me out with the syntax?

Thanks!
Paul Prewett

 

[link9]

update heCustRK set cmiID =
(select unit from yanli.tempTable where yanli.tempTable.rk = heCustRK.rk)

 

[foxdev]

Or possibly:

[tt]update heCustRK
set unit = tempTable.unit
from tempTable
where heCustRK.rk = tempTable.rk
[/tt]
Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[tlbroadbent]

Here is the correct syntax for SQL Server.

UPDATE heCustRK SET unit = tempTable.unit
FROM heCustRK Inner Join tempTable
ON heCustRK.rk = tempTable.rk Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous