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

最新推荐文章于 2023-04-06 17:03:24 发布

西楚三少

最新推荐文章于 2023-04-06 17:03:24 发布

阅读量380

点赞数

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/cai4561/article/details/109184794

版权

子查询


    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

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