I Have three tables and I want to run a delete query the query brings up the right data but error with please specify the table to delete from The tables are Class Pupils and SkatingRecord the SQL is
DELETE SkatingRecord.*, Class.ClassName
FROM (Class INNER JOIN Pupils ON Class.ClassID = Pupils.ClassID) INNER JOIN SkatingRecord ON Pupils.PupilID = SkatingRecord.PupilID
WHERE (((Class.ClassName)="new"));
Any help would be great
Phil
DELETE SkatingRecord.*, Class.ClassName
FROM (Class INNER JOIN Pupils ON Class.ClassID = Pupils.ClassID) INNER JOIN SkatingRecord ON Pupils.PupilID = SkatingRecord.PupilID
WHERE (((Class.ClassName)="new"));
Any help would be great
Phil