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.
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