I have a table with prod_code and supplier_code.
I want to update my main table only when my prod_code and supplier_code is found in my table B
I am having doubt to assemble this
update siaprod set pro_pven where exists (select * from table B)
my siaprod has two field that has in table B
how can I do this?