Update Query 2

[alexkeel79]

I am trying to write and update query where the 'newvalue' is the value in another table.

Ex.

Tbl1 Elements
- ID
- newVal

Tbl2 Elements
- ID
- updateVal

I am trying to write an update query where in Tble2 updateVal becomes newVal in Tbl1 matching on ID. Is it possible to write an update query in this way?

 

[fredericofonseca]

search these forums from

update set select where

and you will find some sample of what you need.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[PHV]

UPDATE Tbl1 INNER JOIN Tbl2 ON Tbl1.ID = Tbl2.ID
SET Tbl1.newVal = Tbl2.updateVal;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886