Home Forums SQL Server 2005 T-SQL (SS2K5) Update a table from select statement results RE: Update a table from select statement results
beeniecopter
SSC Enthusiast
Points: 122
More actions
April 22, 2008 at 2:44 pm
#805778
Gail,
I'm new to TSQL and have similar nonfunctional update statement:
set FDIT_SAP_IMPORT.auc=FDIT_SAP_AUC_IMPORT.auc
from FDIT_SAP_IMPORT
where FDIT_SAP_AUC_IMPORT.wbsnumber=FDIT_SAP_IMPORT.wbsnumber;
Any Ideas?