1、 SELECT employees.*FROM employees, clientsWHERE employees.client_id = clients.idAND clients.name LIKE ‘a%‘;2、适用临时表3、修改表结构，使能够应用索引