[RBASE-L] - Re: Update one table to match another

[ttc . inc]

Try.... 


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


You have an extra T1 after the SET. 

The syntax knows what table is being updated since the 

command is UPDATE CurrentProjectInfo Set "column name".  

Therefore you do not place the table correlation number for 

the column being updated. 



-Bob 




----- Original Message ----- 
From: "Charles Parks" <c...@bgark.com> 
To: "RBASE-L Mailing List" <rbase-l@rbase.com> 
Sent: Monday, February 1, 2010 1:55:39 PM GMT -06:00 US/Canada Central 
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?