Beginner Level in SQL - 4 - Joining Multiple Tables

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 ! :slight_smile:

Which table has eight rows? You won’t see rows for clients who have not made any payments.

1 Like

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