Question · SQL and MySQL course · Module 7: Joining tables (JOIN)
Why table aliases
Why do we use the aliases k and a in FROM ksiazki k INNER JOIN autorzy a?
Answer options
- To permanently rename the tables in the database
- To refer to columns more shortly and unambiguously, e.g. k.tytul and a.nazwisko
- To make MySQL faster thanks to shorter names
- Aliases are required; without them the query always fails
You can check the correct answer by solving this task in the CodeWorlds game.