Home Forums SQL Server 2005 T-SQL (SS2K5) Update a table from select statement results RE: Update a table from select statement results

  • 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?