返回所有店铺的资料,即使店铺负责人为空
select s.shop_name,d.dept_name,d.dept_id,e.emp_name,e.emp_id from cms.shop s,cms.dept d left outer join cms.emp e on d.prin_id =e.emp_id where s.shop_id=d.shop_id
返回所有店铺的资料,即使店铺负责人为空
select s.shop_name,d.dept_name,d.dept_id,e.emp_name,e.emp_id from cms.shop s,cms.dept d left outer join cms.emp e on d.prin_id =e.emp_id where s.shop_id=d.shop_id