SELECT p.prod_name, o.quant_sold
FROM 
    (
        SELECT a.prod_id, SUM(a.quantity) as quant_sold
        from OrderItems a
        group by a.prod_id
    ) o, Products  p
where o.prod_id =  p.prod_id;