SQL Help 1

[dndaughtery]

I need to update a field in a table called "RejectCollections" with a value from a temp table with the name "TigerTemp" based on matching fields called "rejectid". Below is what I have, will this work correctly?


Update RejectCollections Set RejectCollections.COLL_TOTAL = TigerTemp.COLL_Total
Where RejectCollections.RejectID = TigerTemp.RejectID

 

[DotNetGnat]

it should be something like this:

Update RejectCollections
Set COLL_TOTAL = T2.COLL_Total
FROM RejectCollections T1
INNER JOIN TigerTemp T2
ON T1.RejectID = T2.RejectID

-DNG