Merging multiple rows
Posted on 2011-04-30
Would it be possible to merge multiple rows from 2 different tables?
Let's say that i have a global table: GLOBAL and a second table: OVERRIDE
The GLOBAL table will contain several columns.
The OVERRIDE table will only contain a few of the columns that are also present in the GLOBAL table.
Here is very clear example of what I'm trying to accomplish:
After running the query, i would get a merged result set such as this:
So, once the query is executed, i would get the merged result set. I hope this doesn't confuse you. Let me know if you need more information.