Forum Discussion
Extra rows adding after Left join
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 ...
hi
Anonymous
this is how different joins worksIf 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!
hi
Anonymous
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!