I'm trying to update one column of a table with the following query:
Set Amt =
WHERE ID IN
(SELECT ID FROM UTable)
I'd like the sum of AMT from Ptable to be placed in Utable but I keep getting various error messages -- can I do this in one update statement -- How would I do it?