Extra rows adding after Left join

[Bharathi_99]

Hello All,

I am facing issue with extra rows adding in left table after left join
I don't have any unique id in column also to remove duplicates, but how to ignore adding of extra rows

Please help me with resolving this
500K rows are adding extra

[Uzi2019 · Accepted solution]

hi  
@Bharathi_99 

this is how different  joins works  

 If you are doing left join so the records which are not matching with right table will also come in left join.that's why you have 500k records extra of left table.

If you want to only have matching records then use 

NATURALINNERJOIN(<LeftTable>, <RightTable>)

I hope I answered your question!