I have two tables.
i need to update a column ( medtronic_billed) in the venn table where the mfg_item_id matching.
in the Venn table when we filter based on the mapped ='OL' and mapped_final = OL and tthen ake the mfg_item_id value and query in the OL table. there might be multiple records in the OL table.
in that case add the vocher amount and update that vocher amount in to venn table medtronic_billed column
Please check attached spread sheets
Please let me know if any questions