Could this solution be wrong?

[avatar87]

EXERCISE LINK:
https://www.codecademy.com/journeys/full-stack-engineer/paths/fscj-22-back-end-development/tracks/fscj-22-designing-relational-databases/modules/wdcp-22-how-do-i-make-and-populate-my-own-database-b9b4e3bb-6987-472c-ad40-9487a92ec9f8/lessons/what-are-database-relationships/exercises/many-to-many-relationship-part-2

QUESTION:
Please see SS below. I’m not understanding why the FROM field is Book but the SELECT is author data.

I am interpreting this as “show me data from author table, but look in book table”

Thank so you for your help!!

[thepitycoder]

@avatar87

QUESTION:
Please see SS below. I’m not understanding why the FROM field is Book but the SELECT is author data.

I am interpreting this as “show me data from author table, but look in book table”

You’re only considering part of the whole SQL query. The full query includes joins, so you’re actually asking for data from two tables book and author with the joins telling the DB engine how the tables involved relate to each other.

I would have expected this to have been explained to you either beforehand, or as part of the sequence you’re doing which leverages it.