I am not even sure how to word this. I tried the join and made sure to connect all of the tables to the most important information. Then I only output the AA, BB, CC columns. So in essence I have 3 free standing columns that are based on the same ID.
Here comes the problem. How do I match these columns with their related row.
I would like to take these 3 columns and append them to the end of the row with the corresponding information.
ex. I have AA|BB|CC and have Name|Number|Date
and want to have Name|Number|Date|AA|BB|CC
(the original rows looked something like my original post description)
but not all rows that had a BB correspond to a row with AA and would I want them to end up looking like this
ex. Name|Number|Date| |BB|CC
I know this is confusing, but I think it is coherent.
Originally posted by andrewst
Join (possibly outer join) the 3 tables on the common columns.