In a recent forum message, a user wrote:
"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
WHERE (((RepairRegion.RegionID)="obs"));
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!
"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
WHERE (((RepairRegion.RegionID)="obs"));
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!
Try using this .
delete from Repairs where exists
(
select * from Repairs where Repairs.Repair_ID=RepairsRegion.Repair_ID and RepairRegion.RegionID=”obs”
)
;
Thank you for sharing experience.