问hibernate向左加入多个where条件

EN

SELECT SUM (lb.QUANTITY*mp.DB_PRICE) 
FROM ledger_balance lb 
LEFT JOIN material_price mp ON (mp.MATERIAL_ID = lb.MATERIAL_ID) 
WHERE lb.QTY_TYPE ='G' 
AND lb.BALANCE_TYPE='CUMU' 
AND lb.CUSTOMER_ID = 13
AND mp.CUSTOMER_ID = 13 AND  lb.MATERIAL_ID IN (226, 230, 362, 365)
AND mp.MATERIAL_ID IN (226, 230, 362, 365);

SELECT SUM (B.quantity*P.dbPrice) 
FROM com.efl.efms.data.domain.common.LedgerBalance as B 
LEFT JOIN com.efl.efms.data.domain.material.MaterialPrice as P   
with (B.materialId = P.materialCatalog.materialId)  
WHERE   B.balanceType=:balanceType 
AND B.qtyType=:qtyType and B.customerId in (:customerId) AND P.customer.customerId IN (:customerId)  
AND B.materialId in (:materialPriceId)  
AND P.materialCatalog.materialId in (:materialPriceId) ;