August 22, 2019
I'm trying to merge large lists of sales and credit memos. I'm using full outer join because I don't want any rows removed. I can see the data has 226k lines of sales and 18k lines of credit memos. I created a new query to merge the two and the total lines is only 227k. I tried flipping the order of the queries in the merge and if I put the credit memos on top, the result is only about 19k lines.
Any ideas why I wouldn't have the full 244k lines in my merged data if im using full outer join? Any ways around this?
July 16, 2010