Does anyone know how to use one field in a table to update a second field in that same table during an update query?
example update table set field2 = field2 + ('numeric_data' * field3) where field1 = 'id_data' thanks for any help.
Okay I just tested the query above and it worked just as I had written it.
