sql delete from 5 linked tables

[martinrobson]

hi,

could someone point me in the right direction.

I have an sql statement which i would like to use to delete a selection from a dropdown vb list.

The SQL i am using is

DELETE FROM tablename A, tablename B, tablename C, tablename D, tablename E where A.ID = B.ID and B_ID = C_ID and C_ID = D_ID and C_ID2 = E_ID and " (the rest is vb)

i get a syntax error, for a missing operator.

Can anyone help,

basically i am trying to delete some data from 5 tables which is all linked to each other with a series of id keys.

thanks

 

[sem]

You may delete only from 1 table in a shot. Though creating FK with ON DELETE CASCADE may need deleting from the parent table only.

Regards, Dima