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.
Hello
I am a full stack developer for over 5 years on the freelancer.com.
I have read your description in more detail and have much interest in your project.
I have many experiences what I have ever done before similar to your project.
I think that I can finish your work perfectly as you need ASAP.
If you need to discuss with me for any kind of suggestions or information, please knock me anytime.
I am looking forward to hearing from you very soon.
Thank you.