子查询
select bep_si_id,bep_emp_id,bep_points,sum(bep_points) as bep_points_sum,bep_state,
(select be.be_photo from t_base_employee be where be.be_id=bep.bep_emp_id ) as be_photo,
(select si_name from t_base_storeinfo bs where bs.si_id=bep.bep_si_id) as bep_si_name,
(select be_name from t_base_employee be where be.be_id=bep.bep_emp_id) as bep_be_name
from t_base_employee_points bep
where ei_id=22 group by bep_emp_id order by bep_points_sum desc
内连接查询
select bep_si_id,bep_emp_id,bep_points,sum(bep_points) as bep_points_sum,bep_state,
be.be_photo as be_photo,
be.be_name as bep_be_name,
bs.si_name as bep_si_name
from t_base_employee_points bep
INNER JOIN t_base_employee be ON be.be_id=bep.bep_emp_id
INNER JOIN t_base_storeinfo bs ON bs.si_id=bep.bep_si_id
where bep.ei_id=22 group by bep_emp_id order by bep_points_sum desc
三表关联查询，两种写法查出来的结果是一样的。
