Database sql query


#1

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 ?


#2

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


#3

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


#4

Exactly