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.