I'm trying to make an update work in Informix. The syntax is below but it does not work. I'm essentially trying to update a table in temp_table where the join on bhrv_invoice_id joins the two tables.
It should be simple but I'm really struggling with it.
set temp_table.load_fuel = temp_load_totals.load_fuel
from temp_table inner join temp_load_totals on temp_table.bhrv_invoice_id = temp_load_totals.bhrv_invoice_id