Hello everyone !
I am having troubles with the lesson “Joining Multiple Tables” (23th video).
When I write the exact same code as the teacher I get a different result. It does not make sense for me. It retrieves only the first fourth rows instead of the eight rows of the table.
Can someone help me please ?
Thank you !
Which table has eight rows? You won’t see rows for clients who have not made any payments.
The payments table has eight rows.
Yesterday, I tried to post a comment below this topic but I couldn’t. In the second JOIN, I used the wrong column name (payment_id) instead of “payment_method”. That’s why the query was getting me four rows instead of eight.
Thank you for your help @eelsholz