Create a view... simple... except when ARTHRITIS PAIN FLARES UP.

The Syntax:

 CREATE
 [OR REPLACE]
 [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
 [DEFINER = { user | CURRENT_USER }]
 [SQL SECURITY { DEFINER | INVOKER }]
 VIEW view_name [(column_list)]
 AS select_statement
 [WITH [CASCADED | LOCAL] CHECK OPTION]
 

SELECT * FROM EmpList;

A real life example... Create a view to see list of employees...

 Create View EmpList
 SELECT LastName, FirstName, MiddleName  FROM Employee Order by LastName, FirstName, MiddleName; 

Execute in like this:

Views do save a lot of time.