I have two tables in the schema.
The first table, violation_codes, has a section_number and fine, among other columns, but these two are the focus of the problem.
The second table, bond, has an orc and fine, among other columns as well.
For each row in the violation_codes table where the section_number equals the orc in the bond table, I need to update the violation_codes.fine column with the fine amount in the bond table.
I have been playing around with a cursor to accomplish this, but haven't had any luck. Any help would be appreciated.