Can someone tell me why this statement doesn't work:

DELETE

FROM OE_HDR, OE_HDR_no_lines

WHERE OE_HDR.KEY_FLD = OE_HDR_no_lines.KEY_FLD

I am trying to delete records from the first table (OE_HDR) where those same records exist in the second table (OE_HDR_no_lines). If I change the "DELETE" to "SELECT *" I get the records I want to delete.

thanx