Re: DELTE with multiple conditions same column does not execute

[Phillip Ward]

What "results" would you expect a Delete to display?
It does what it's told - deletes whatever rows it finds that meet the given [where] criteria. Depending on where you run it from, it might tell you how many rows it got rid of.

The syntax is little odd - unless you're actually dealing with lots (and lots) of values, I'd expect to see a "NOT IN" clause here:

DELETE FROM debiteure
WHERE Debiteur = 'Cash-Kelder' 
AND groepnaam NOT IN ( 'SUBSIDIARY', 'UITVOER - ZAR', 'BULK WINE', 'UITVOER - EURO' ) ;

Regards, Phill W.