Database sql query

I dont understand the red marked part in my book.

Is this query correct ?
book is using live e , live m . Why its used twice ?

Could you please explain whats going on here ?

when the same table is used twice in a query, the table names need to have table aliases so that the database knows what to do with each copy of the table

in your case, the “managers” table links people to their managers, and if you want both names returned in the query, you join one copy of the “live” table to the person, and the other copy of the “live” table to the manager

1 Like

what do you mean both names ? do you mean people name and his manager name …is it ?

Exactly

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.