Resolved: Why not left join?

Question

Hi,

I just want to understand why we are not using left join here and using inner join instead? Kindly respond. Would like to learn.

Thanks

Abhi

Answer 1

Hi Abhilasha,

thanks for reaching out! You're correct that we can use a left join in this instance. In that case, we'd have all customers, as well as all customers, who've made a purchase. In my case, I wanted to analyse the behaivour of paying customers only, that's why I opt for the inner join instead.

Hope this helps!

Best,

365 Eli

Answer 2

Abhilasha Narasimhan

Posted on:

07 Nov 2023

0

Thank you, makes sense!

Resolved: Why not left join?

Submit an answer

related questions