"Hello, I'm working with two tables. One is the "Repairs" table and the other is the "RepairRegion" table. I'm attempting to delete any/all record(s) in the "Repairs" table that is in the "OBS" region in the "RepairRegion" table. Here is the query:
DELETE Repairs.*, RepairRegion.RegionID
FROM Repairs INNER JOIN RepairRegion ON Repairs.Repair_ID = RepairRegion.RepairID
I receive the error message "Could not delete from specified tables".What do you suppose that I'm doing wrong?? Thank you for looking at this."
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!