Simple Merge problem in MS SQL. URGENT

Merge two tables with SQL query

I have two tables inside database ‘ChemeterData’ which need to be merged. Though a simple task, my knowledge with SQL is too limited to figure this out.

Table 1. ([login to view URL])

Colums:

Product_Code ; Product_Name; Brand; Language; HSentences; PSentences; Pictogram1; Pictogram2; Pictogram3; Pictogram4; Pictogram5; Signal_words; Priority_Warning; SubstancesContributingClassification

Table 2. ([login to view URL])

Columns:

Product_Code; Brand

The problem is that inside Table 2, Brand has data inside it. This data needs to be placed inside ‘Brand’ in table 1. under Brand.

I know this can be done, since Product_Code inside table 1 is exactly the same as in table 2, so based on Product_Code, the Brand has to be filled in Table 1.

Database Programming SQL

Project ID: #18822085

About the project