如何在mySQL中同时“别名”表和所有列？

I'm trying to use natural join to join two tables in mySQL that have a field that is equivalent, but named differently between the tables (I have to use natural join -- I know it would be easier to use a different join). Natural join looks for fields with the same name, so I want to rename the column in one table to the same name as the one in the other table. In my textbook (not specific to mySQL) it says that the following should work:I'm trying to use natural join to join two tabl