update table

[salgergawi]

Hello,
How can I update (some columns) in a table from the same table based on a Criteria column in the same table.

 

[jdraw]

see http://www.w3schools.com/sql/sql_update.asp

 

[salgergawi]

Many thanks