This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Am presenting the challenge I'm looking to solve below. Following my research and searching, I'm at this point afraid to use the word join, union, append, or merge in this post as I'll probably mis-use it. So I'll just paste my info below. I'm seeing many posts that are allowing me to learn and 'almost' get to my desired result... but not yet there. I'll continue to research but if there's an ACE out there who has a quick solution I would take it :)
At a future date, I hope to be embarrassed at missing the simplicity of the solution I missed .....
Nuances in below:
I'm adding Table 2 column (Color) to Table A information
- if ID from Table 2 Exists in Table 1 already, then just add the new column value (ID#1 for example)
- if ID from Table 2 doesn't exist in Table 1, then add ID as new row along with new column value (ID#4 for example)