Hi,

I've 4 tables from which i need to delete rows. Below are the tables:

Table s
Table a
Table v
Table p

1. Column a_sid of table "a" references column s_id of table "s" where s_id is primary key so as a_sid.
2. Column v_sid of table "v" references column s_id of table "s"
3. Column p_sid of table "p" references column s_id of table "s"

I need to delete all rows of 4 tables where a_type of "a" table = "AC"

Please help.
Thanks,
Ramki