Hi all,

How to do multiple deletion with many tables in SQL ?

table1
number
desc

table2
number
desc2

table3
desc2
id

table4
id
amount

table5
amount
supplier

....

this is a parent to children deletion in a single SQL - statment if possible

table1 and table2 linked with number
table2 and table3 linked with desc2
table3 and table4 linked with id
table4 and table5 linked with amount

and so on

Any suggestions or coding would be appreciated very much.
TIA