Merge queries issue.

[RenataOG30s]

Hello folks,

Why would a left outer join reduce the number of rows?

Thanks in advance.

R

[v-easonf-msft]

Hi, @RenataOG30s 

Which table do you compare the result table with, the first table or the second table?

Best Regards,
Community Support Team _ Eason

[RenataOG30s]

1st table is my main table, and I want to bring the matches from the second table.

[v-easonf-msft]

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

[amitchandak]

@RenataOG30s , left should not reduce rows. Unless the join column has null/blank value on the left side.

Can you share sample data ?