子查询与内连接查询应用实例

子查询


    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

三表关联查询，两种写法查出来的结果是一样的。