select
    p.prod_name,
    o.quantity
from
    Products p
    left join (
        select prod_id,sum(quantity) quantity from OrderItems group by prod_id
    ) o on p.prod_id = o.prod_id