I am attempting to build a view with four filters (A, B, C, D). With Views 3 it is possible to select whether you want these filters to be chained with AND statements or OR statements. Is there a way to configure views so as to chain some of them with AND and others with OR?

For example, ending up with a query that is similar to:

SELECT * 
FROM {table} 
WHERE A = 0
  AND B = 0
  AND (C = 1 OR D = 1)`