Forum Discussion
RenataOG30s
4 years agoFrequent Visitor
Merge queries issue.
Hello folks, Why would a left outer join reduce the number of rows? Thanks in advance. R
RenataOG30s
4 years agoFrequent Visitor
1st table is my main table, and I want to bring the matches from the second table.
v-easonf-msft
4 years agoCommunity Support
Hi, RenataOG30s
It's really weird. When using left outer join, all data in the first table will be retained.
Can you show relevant screenshots? Have you checked the missing rows in 1st table?
Best Regards,
Community Support Team _ Eason