SQL Delete

[PeteAmsterdam]

Do you know how to write a delete statement to delete by a composite
key/

I can do it by one, but 3 doesn't seem to work

 

[hmckillop]

???

DELETE MyTable
WHERE field1inCompKey = 'xyz' and field2incompkey = 'abc' and field3incompkey = 'def'

do you mean something other than that?


"I'm living so far beyond my income that we may almost be said to be living apart