Charlie, I don't think you need the t1. In the SET statement, just the T2.
Duey From: [email protected] [mailto:[email protected]] On Behalf Of Charles Parks Sent: Monday, February 01, 2010 1:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Update one table to match another 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?
