Delete Query (1 Viewer)

philedg

New member
Local time
Today, 10:04
Joined
Feb 13, 2016
Messages
2
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:04
Joined
May 7, 2009
Messages
19,169
DELETE SkatingRecord.* FROM SkatingRecord Inner Join (Pupils ON SkatingRecord.PupilID = Pupils.PupilID) INNER JOIN Class On Pupils.ClassID = class.ClassID WHERE ((Class.ClassName) = "new");
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:04
Joined
May 7, 2009
Messages
19,169
i think the above didn't work either, try this:

DELETE SkatingRecord.* from SkatingRecord where exists (select * from Pupils inner join Class on Pupils.ClassID=Class.ClassID where Pupils.PupilID = SkatingRecord.PupilID and Class.ClassName="new")
 

philedg

New member
Local time
Today, 10:04
Joined
Feb 13, 2016
Messages
2
Just checking but the second version seems to work thanks
 

Users who are viewing this thread

Top Bottom