MySQL™: The World’s Most Popular Open Source Database 157 4.0: Multiple table DELETE • Allows you to delete rows in multiple tables bases of conditions from multiple tables • Like saying that you want to delete all rows found by a SELECT • Syntax inspired by MS Access • DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id and t2.id=t3.id Copyright 2003 MySQL AB