How would I delete rows from three tables in one query?

[cherold]

I have 3 tables, Compositions, Discs, and DiscContents (which connects a row in Compositions to a row in Discs).

How would I write a Delete Query that would do these three deletes in one fell swoop (I'll hardcode ID numbers for this example)?

DELETE FROM Compositions WHERE CompositionID = 424

DELETE FROM Discs WHERE DiscID = 320



DELETE FROM DiscContents WHERE composition_id = 424 and disc_id = 320

[CJ_London]

you don't, you have to use three separate queries

however if your relationships are set up to maintain referential integrity and you have selected Cascade delete related records then deleting the primary table record (on the one side of the relationship) will also delete all the related records in the child table(s)

otherwise you will need to run some code to run each query in sequence - and bearing in mind if you have set referential integrity, you will need to delete the child records first. Code would be something like

currentdb.execute "DELETE FROM Compositions WHERE CompositionID = 424"
currentdb.execute "DELETE FROM Discs WHERE DiscID = 320"
currentdb.execute "DELETE FROM DiscContents WHERE composition_id = 424 and disc_id = 320"