Resolved: Why not left join?
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 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!