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?

