@jkon: because I am trying to delete both table using PHP and it doesn excute both of the query.
@paulraj.. I am getting an error message, which I been getting for all the other methods I have tired.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as t1 WHERE t1.Tes_ID = 12 AND t1.Tes_ID IN (SELECT t2.Tes' at line 1
@ardav... I do have foreign key. These two tables are actually linked by Tes_ID.
I think they need to be constrained though. ROLLUP should automatically delete any related records.