A table alias, defined after the table name in FROM or JOIN, shortens references and resolves ambiguities between columns with the same name. It is essential for joining a table to itself. Once defined, the alias is what you must use in the query.
Example
FROM commandes AS o JOIN clients AS c ON c.id = o.client_id