I needed to add two more fields to a table. I need to make the update of these two columns with the corresponding fields from the other table. I have a common key to both tables. However there are some records in a table that does not exist in the other, and I would leave them to zero.
How can make update query.