SQL Query correction

Job ID: 33887427

Budget: $10 – $30 USD

Need to fix an sql query:
Table A (values)
Table B (values)

Both tables have primary key and I want to update table b with table a data.
As there is data based on primary key, I want to update data for existing and non existing to insert new data.
Needs to use SQL Procedure

Budget is 10$. Please agree to the budget in writing so we can proceed. no template responses please.