Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 help me with resolving this
500K rows are adding extra

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    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!

     

     

1 Reply

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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!