If I try to execute this command:

UPDATE CurrentProjectInfo +
SET t1.ProjNum = t2.ProjNum +
FROM CurrentProjectInfo t1, NewProjectInfo t2 +
WHERE t1.WBS1=t2.WBS1

I get an error ProjNum is an undefined table.  I have verified the column 
ProjNum exists in both CurrentProjectInfo and NewProjectInfo.

Is there reason why ProjNum is being treated as a table?  Can I update the 
column in one table to match the value in another table?

Reply via email to