Forum Discussion
Merge Two Tables with Left Outer Join While Keeping All Rows From First Table (Matched or Unmatched)
We'll need some more detail please to find out what's going on. Experience tells us that a left-outer join will correctly retain unmatched rows from the 'left' table.
If you want more help, please provide a small sample that illustrates the problem or provide some pictures of the before and after effects of the join (with a picture of the Merge join screen)
We'll need some more detail please to find out what's going on. Experience tells us that a left-outer join will correctly retain unmatched rows from the 'left' table.
If you want more help, please provide a small sample that illustrates the problem or provide some pictures of the before and after effects of the join (with a picture of the Merge join screen)
Thanks for the reply. You were right! The left outer join should retain the unmatched rows.
I remembered that merging tables will sometimes jumble the order of the rows so I sorted the primary key column and all the unmatched rows were there.