目录 一、题目二、代码三、运行结果 一、题目 二、代码 select pro.prod_name,table1.sum from Products pro join ( select ord.prod_id, sum(ord.quantity) as sum from OrderItems ord group by ord.prod_id ) table1 on pro.prod_id = table1.prod_id 三、运行结果