Okay Steve, feel responsible for my broken screen 🙂

As geervani indicated you can definitely use FROM clause in UPDATE but not in the example given.

I would do:

update a1

Set a1.column= a2.column

From table as a1 inner...

That's fine Lynn ... but I suppose the joke should be hinted toward SQL activities.

I see no connection here 😉

Victor

Edit your

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI keys to contain the following:

a) "OracleOciLib"="oci.dll"

b) "OracleXaLib"="oraclient9.dll".

c) "OracleSqlLib"="orasql9.dll"

Then reboot your server. (I'm assuming the Oracle linked server is Oracle 9i)

Victor