目录 一、题目二、代码三、运行结果 一、题目 二、代码 select table1.need_pro_id,count(table1.all_id) from ( select ve.vend_id as need_pro_id, pro.vend_id as all_id from Vendors ve left join Products pro on ve.vend_id = pro.vend_id ) table1 group by table1.need_pro_id order by table1.need_pro_id 三、运行结果