P
Phil
Hi,
I am trying to delete records from one table where they appear in another, I
have joined the 2 tables see code below -:
DELETE Inspection.*
FROM Inspection INNER JOIN IN_NRDANG_1205 ON Inspection.InspectionID =
IN_NRDANG_1205.InspectionID;
But I keep getting the message Could not delete fro specified table, I am
not refering to the second table in the delete so I cannot work out why it
wont delete, does anyone have any ideas?
I am trying to delete records from one table where they appear in another, I
have joined the 2 tables see code below -:
DELETE Inspection.*
FROM Inspection INNER JOIN IN_NRDANG_1205 ON Inspection.InspectionID =
IN_NRDANG_1205.InspectionID;
But I keep getting the message Could not delete fro specified table, I am
not refering to the second table in the delete so I cannot work out why it
wont delete, does anyone have any ideas?