Hello,
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?
Thanks
Hi D,
When you Merge tables it doesn't add the rows directly below the first table. That would be an Append. A merge will match rows where possible and only rows that don't have a match will be added to the bottom of the first table.
Mynda