Update problem

• vidyap7

  SSC-Addicted

  Points: 427

  More actions

  March 20, 2003 at 1:21 pm

  #79744

  Hi,

  I need to update a table with data from the same table. This is what I want to do:

  UPDATE AP_FTS_Working

  SET FTSTab = '1',

  ReferenceTN = W2.TN

  FROM AP_FTS_Working W INNER JOIN AP_FTS_Working W2

  ON W.Acct_No = W2.Acct_No

  WHERE W2.FTSTab = '0'

  AND W.FTSTab IS NULL

  However, I get the following error:

  Server: Msg 8154, Level 16, State 1, Line 1

  The table 'AP_FTS_Working' is ambiguous.

  Could you help please?

  Thanks,

  VP

• mromm

  SSCarpal Tunnel

  Points: 4301

  More actions

  March 20, 2003 at 1:27 pm

  #451622

  UPDATE W

  SET FTSTab = '1',

  ReferenceTN = W2.TN

  FROM AP_FTS_Working W

  JOIN AP_FTS_Working W2

  ON W2.FTSTab = '0'

  AND W.FTSTab IS NULL

  AND W.Acct_No = W2.Acct_No

• vidyap7

  SSC-Addicted

  Points: 427

  More actions

  March 20, 2003 at 1:36 pm

  #451623

  Thanks mromm, that worked 🙂

  VP