Table Aliases

•Use table aliases to simplify queries
•Use table aliases to improve performance
•Table aliases help to keep SQL code smaller, there for less memory will be used

Select e.employee_id, e.last_name, d.location_id, department_id
From employees e join departments d
Using (department_id);



The EMPLOYEES table has been given alias of e and DEPARTMENTS table an alias of d.