Sherry,

Did you want to know why it works well, or are you having a problem?

It works because the E,F, and G are not table names they are alias names referring to the same table.