 select L.product_id, P.product_desc, sum(L.quantity) from 
RETAILBUYER_PRODUCT_SOURCE P
INNER JOIN
RETAILBUYER_POLINEITEM L
ON P.PRODUCT_ID = L.PRODUCT_ID
GROUP BY L.PRODUCT_ID, P.product_desc
order by sum(L.quantity) desc