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
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