Consider the following table:

 
   A  B  C  D
 
   4  5  1  7
   4  5  2  8

And the where clause being D = 7. Then your select would return just one line, and miss the C = 2. If you first select the A = 4, B = 5, and then go for the C, you get both lines.

Abigail