Another option:

SELECT pd.CustID

FROM Product_Details pd

LEFT JOIN (SELECT CustID FROM Product_Details WHERE ProdID = 0) c ON pd.CustID = c.CustID

WHERE pd.ProdID IN (1, 4)

AND c.CustID IS NULL

GROUP BY pd.CustID

HAVING COUNT(*) = 2